>>>>> "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
