>>>>> "Poul" == Poul Christiansen <poul@stripped> writes:
Poul> I'm trying to execute the attached SQL statemnet using MS IIS 4.0 and ASP
Poul> against a MySQL Database
Poul> The attachment also conatins the error!
Poul> Is the string too long or what is wrong with this?
Poul> Best regards
Poul> Poul Christiansen - mailto:poul@stripped
Poul> AP Consult ApS - http://www.ap-consult.dk
Hi!
First; PLEASE don't post messages in HTML format to any mailing list!
Many users really HATES this as this only makes your mailbox larger
without providing more informations.
Poul> insert into asplog (dato, all_http, all_raw, appl_md_path, appl_physical_path, auth_password, auth_type, auth_user, cert_cookie, cert_flags, cert_issuer, cert_keysize, cert_secretkeysize, cert_serialnumber, cert_server_issuer, cert_server_subject, cert_subject, content_length, content_type, gateway_interface, https, https_keysize, https_secretkeysize, https_server_issuer, https_server_subject, instance_id, instance_meta_path, local_addr, logon_user, path_info, path_translated, query_string, remote_addr, remote_host, remote_user, request_method, script_name, server_name, server_port, server_port_secure, server_protocol, server_software, url, http_accept, http_accept_language, http_host, http_user_agent, http_pragma, http_cookie, http_authorization, http_accept_encoding) values (19990426091409, "HTTP_ACCEPT:*/* HTTP_ACCEPT_LANGUAGE:da HTTP_HOST:extranet.ap-consult.dk HTTP_USER_AGENT:Mozilla/4.0 (compatible; MSIE 4.01; Windows NT) HTTP_PRAGMA:No-Cache HTTP_COOKIE:ASPSESSIONIDGGQGGGBH=BJEPFDHBHLJGKLMIBDLHJMEL HTTP_AUTHORIZATION:Basic cG91bDprbG9ra2U= HTTP_ACCEPT_ENCODING:gzip, deflate ", "Accept: */* Accept-Language: da Host: extranet.ap-consult.dk User-Agent: Mozilla/4.0 (compatible; MSIE 4.01; Windows NT) Pragma: No-Cache Cookie: ASPSESSIONIDGGQGGGBH=BJEPFDHBHLJGKLMIBDLHJMEL Authorization: Basic cG91bDprbG9ra2U= Accept-Encoding: gzip, deflate ", "/LM/W3SVC/9/Root", "E:\Inet\dk\ap-consult\extranet\", "kikke", "Basic", "poul", "", "", "", "", "", "", "", "", "", "0", "", "CGI/1.1", "off", "", "", "", "", "9", "/LM/W3SVC/9", "195.249.53.7", "poul", "/apconsultdk/default.asp", "E:\Inet\dk\ap-consult\extranet\apconsultdk\default.asp", "", "195.249.53.2", "195.249.53.2", "poul", "GET", "/apconsultdk/default.asp", "extranet.ap-consult.dk", "80", "0", "HTTP/1.0", "Microsoft-IIS/4.0", "/apconsultdk/default.asp", "*/*", "da", "extranet.ap-consult.dk", "Mozilla/4.0 (compatible; MSIE 4.01; Windows NT)", "No-Cache", "ASPSESSIONIDGGQGGGBH=BJEPFDHBHLJGKLMIBDLHJMEL", "Basic cG91bDprbG9ra2U=", "gzip, deflate");
Poul> Microsoft OLE DB Provider for ODBC Drivers error '80040e09'
Poul> [TCX][MyODBC]You have an error in your SQL syntax near 'kikke", "Basic", "poul", "", "", "", "", "", "", "", "", "", "0", "", "CGI/1.1"' at line 1
Poul> /apconsultdk/scripts/log.asp, line 56
The problem is that MySQL uses '\' to escape characters. If you
change all '\' to '\\', you should be able to get the above to work!
Regards,
Monty
