List:General Discussion« Previous MessageNext Message »
From:Adrian Phillips Date:March 19 2000 7:24am
Subject:Re: NEWBEE:email address and DER formatted certificate questions
View as plain text  
>>>>> "Murrah" == OTR Comm <otrcomm@stripped> writes:

    Murrah> Hello, I apologize if this is in the FAQs, but could some
    Murrah> one tell me please how I can store an email adress in
    Murrah> MySQL?

    Murrah> I have tried to set the field typ as VARCHAR(30), but this
    Murrah> does not work.  What format should I use?

    Murrah> I have a query like so:

                 
    Murrah> $SQL = "INSERT INTO certificates"; $SQL .= "
    Murrah>
(Country,State,Location,Organization,OrganizationUnit,CommonName,Email,SessionId,";
    Murrah> $SQL .= "CertId,req,msie_req_raw,request_date,client_type)
    Murrah> "; $SQL .= "VALUES "; $SQL .=
    Murrah>
"(\"$Country\",\"$State\",\"$Location\",\"$Organization\",\"$OrganizationUnit\",\"$CommonName\",";
    Murrah> $SQL .=
    Murrah>
"\"$Email\",\"$sessionId\",\"$certId\",\"$reg\",\"$msie_req_raw\",\"$date\",\"M\");";

If this is perl DBI, then try perldoc DBI and check for placeholders
(you have problems with quoting data and placeholders is the best
solution).

Sincerely,

Adrian Phillips
Thread
NEWBEE:email address and DER formatted certificate questionsOTR Comm19 Mar
  • Re: NEWBEE:email address and DER formatted certificate questionsAdrian Phillips19 Mar