From: Keith Waterworth Date: April 26 1999 9:01am Subject: Re: ODBC Error List-Archive: http://lists.mysql.com/mysql/2380 Message-Id: <010e01be8fc3$562df640$12660a0a@intranet.manxairlines.com> MIME-Version: 1.0 Content-Type: multipart/signed; boundary="----=_NextPart_000_0108_01BE8FCB.B64598A0"; micalg=SHA1; protocol="application/x-pkcs7-signature" ------=_NextPart_000_0108_01BE8FCB.B64598A0 Content-Type: multipart/alternative; boundary="----=_NextPart_001_0109_01BE8FCB.B64598A0" ------=_NextPart_001_0109_01BE8FCB.B64598A0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable I'm not sure about this as I am new to SQL/ODBC but the field = "E:\Inet\dk\ap-consult\extranet\" the last \ may be causing the closing = quote to be taken as a literal as it does in C. I do not know of a way = to get round the problem though apart from not having fields ending in a = \ Best Regards Keith. ----- Original Message -----=20 From: Poul Christiansen=20 To: Mysql Mailing List (E-mail)=20 Sent: 26 April 1999 08:16 Subject: ODBC Error I'm trying to execute the attached SQL statemnet using MS IIS 4.0 and = ASP against a MySQL Database =20 The attachment also conatins the error! =20 Is the string too long or what is wrong with this? Best regards Poul Christiansen - mailto:poul@stripped AP Consult ApS - http://www.ap-consult.dk=20 -------------------------------------------------------------------------= ----- --------------------------------------------------------------------- Please check "http://www.mysql.com/Manual_chapter/manual_toc.html" = before posting. To request this thread, e-mail = mysql-thread2375@stripped To unsubscribe, send a message to the address shown in the List-Unsubscribe header of this message. If you cannot see it, e-mail mysql-unsubscribe@stripped instead. ------=_NextPart_001_0109_01BE8FCB.B64598A0 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
I'm not sure about this as I am new to SQL/ODBC but = the field=20 "E:\Inet\dk\ap-consult\extranet\" the last \ may=20 be causing the closing quote to be taken as a literal as = it does=20 in C. I do not know of a way to get round the problem though apart from = not=20 having fields ending in a \
 
Best Regards
 
Keith.
 
----- Original Message -----
From:=20 Poul=20 Christiansen
To: Mysql Mailing=20 List (E-mail)
Sent: 26 April 1999 08:16
Subject: ODBC Error

I'm=20 trying to execute the attached SQL statemnet using MS IIS 4.0 and ASP = against=20 a MySQL Database
 
The=20 attachment also conatins the error!
 
Is=20 the string too long or what is wrong with this?

Best regards

Poul Christiansen - mailto:poul@stripped
AP Consult ApS - http://www.ap-consult.dk

 

=

------------------------------------------------------------------= ---
Please=20 check "http://www.mysql.com/Manual_chapter/manual_toc.html" = before
posting.=20 To request this thread, e-mail = mysql-thread2375@stripped

To=20 unsubscribe, send a message to the address shown in = the
List-Unsubscribe=20 header of this message. If you cannot see it,
e-mail=20 mysql-unsubscribe@stripped instead. ------=_NextPart_001_0109_01BE8FCB.B64598A0-- ------=_NextPart_000_0108_01BE8FCB.B64598A0 Content-Type: application/x-pkcs7-signature; name="smime.p7s" Content-Transfer-Encoding: base64 Content-Disposition: attachment; filename="smime.p7s" MIAGCSqGSIb3DQEHAqCAMIACAQExCzAJBgUrDgMCGgUAMIAGCSqGSIb3DQEHAQAAoIII7TCCAnsw ggHkoAMCAQICAwDGvDANBgkqhkiG9w0BAQQFADCBuTELMAkGA1UEBhMCWkExFTATBgNVBAgTDFdl c3Rlcm4gQ2FwZTEUMBIGA1UEBxMLRHVyYmFudmlsbGUxGjAYBgNVBAoTEVRoYXd0ZSBDb25zdWx0 aW5nMSkwJwYDVQQLEyBUaGF3dGUgUEYgUlNBIElLIDE5OTguOS4xNiAxNzo1NTE2MDQGA1UEAxMt VGhhd3RlIFBlcnNvbmFsIEZyZWVtYWlsIFJTQSBJc3N1ZXIgMTk5OC45LjE2MB4XDTk5MDQxNTA4 MTAyOVoXDTAwMDQxNDA4MTAyOVowTDEfMB0GA1UEAxMWVGhhd3RlIEZyZWVtYWlsIE1lbWJlcjEp MCcGCSqGSIb3DQEJARYaa2VpdGhAaW0ubWFueC1haXJsaW5lcy5jb20wXDANBgkqhkiG9w0BAQEF AANLADBIAkEAsgEbnw9cFas81HeuWAncg8xs46qcd3aL4mKXRfRdP8EtIrhRttHlVOs7ivQSKvim IS8oUE0CBvrcWD96PTn8DQIDAQABo0EwPzAOBgNVHQ8BAf8EBAMCBaAwDAYDVR0TAQH/BAIwADAf BgNVHSMEGDAWgBT+PmCca4wPsNgzxsrGHliwcTi14DANBgkqhkiG9w0BAQQFAAOBgQBj9e28q/Rw bXxlTIGUwUFnjUzYWYSCI5jYAIyU1EqUi4RhYd7qwFRb7tFRURNu4RkFqFHToLweRUdC7PviJFpQ uCzxFlPKnWrBcgM8TAnQaawBGLBEYu096r2FbtyRcTq3zThbDZP+c7vKS/ENKb7CFmDTLgBmnbdv P8ZZT9Fu+zCCAy0wggKWoAMCAQICAQAwDQYJKoZIhvcNAQEEBQAwgdExCzAJBgNVBAYTAlpBMRUw EwYDVQQIEwxXZXN0ZXJuIENhcGUxEjAQBgNVBAcTCUNhcGUgVG93bjEaMBgGA1UEChMRVGhhd3Rl IENvbnN1bHRpbmcxKDAmBgNVBAsTH0NlcnRpZmljYXRpb24gU2VydmljZXMgRGl2aXNpb24xJDAi BgNVBAMTG1RoYXd0ZSBQZXJzb25hbCBGcmVlbWFpbCBDQTErMCkGCSqGSIb3DQEJARYccGVyc29u YWwtZnJlZW1haWxAdGhhd3RlLmNvbTAeFw05NjAxMDEwMDAwMDBaFw0yMDEyMzEyMzU5NTlaMIHR MQswCQYDVQQGEwJaQTEVMBMGA1UECBMMV2VzdGVybiBDYXBlMRIwEAYDVQQHEwlDYXBlIFRvd24x GjAYBgNVBAoTEVRoYXd0ZSBDb25zdWx0aW5nMSgwJgYDVQQLEx9DZXJ0aWZpY2F0aW9uIFNlcnZp Y2VzIERpdmlzaW9uMSQwIgYDVQQDExtUaGF3dGUgUGVyc29uYWwgRnJlZW1haWwgQ0ExKzApBgkq hkiG9w0BCQEWHHBlcnNvbmFsLWZyZWVtYWlsQHRoYXd0ZS5jb20wgZ8wDQYJKoZIhvcNAQEBBQAD gY0AMIGJAoGBANRp19SwlGRbcelH2AxRtupykbCEXn0tDY97Et+FJXUodDpCLGMnn5V7S+9+GYcd huqj3bnOlmQawhRuRKx85o/oTQ9xH0A4pgCjh3j2+ZSGXq3qwF5269kUo11uenwMpUtVfwYZKX+e mibVars4JAhqmMex2qOYkf152+VaxBy5AgMBAAGjEzARMA8GA1UdEwEB/wQFMAMBAf8wDQYJKoZI hvcNAQEEBQADgYEAx+ySfk749ZalZ2IqpPBNEWDQb41gWGGsJrtSNVwIzzD7qEqWih9iQiOMFw/0 umScF6xHKd+dmF7SbGBxXKKs3Hnj524ARx+1DSjoAp3kmv0T9KbZfLH43F8jJgmRgHPQFBveQ6mD JfLmnC8Vyv6mq4oHdYsM3VGEa+T40c53ooEwggM5MIICoqADAgECAgEKMA0GCSqGSIb3DQEBBAUA MIHRMQswCQYDVQQGEwJaQTEVMBMGA1UECBMMV2VzdGVybiBDYXBlMRIwEAYDVQQHEwlDYXBlIFRv d24xGjAYBgNVBAoTEVRoYXd0ZSBDb25zdWx0aW5nMSgwJgYDVQQLEx9DZXJ0aWZpY2F0aW9uIFNl cnZpY2VzIERpdmlzaW9uMSQwIgYDVQQDExtUaGF3dGUgUGVyc29uYWwgRnJlZW1haWwgQ0ExKzAp BgkqhkiG9w0BCQEWHHBlcnNvbmFsLWZyZWVtYWlsQHRoYXd0ZS5jb20wHhcNOTgwOTE2MTc1NTM0 WhcNMDAwOTE1MTc1NTM0WjCBuTELMAkGA1UEBhMCWkExFTATBgNVBAgTDFdlc3Rlcm4gQ2FwZTEU MBIGA1UEBxMLRHVyYmFudmlsbGUxGjAYBgNVBAoTEVRoYXd0ZSBDb25zdWx0aW5nMSkwJwYDVQQL EyBUaGF3dGUgUEYgUlNBIElLIDE5OTguOS4xNiAxNzo1NTE2MDQGA1UEAxMtVGhhd3RlIFBlcnNv bmFsIEZyZWVtYWlsIFJTQSBJc3N1ZXIgMTk5OC45LjE2MIGfMA0GCSqGSIb3DQEBAQUAA4GNADCB iQKBgQDEpeXU1NBfCALuByF9JL+ra44e6yAHAhWEa4/QkyQfG53uaLK5LE/pk2cXEBceoflDQSO5 MKp2l7vz5/2BwLUxi/amUCZU8pUo6xmkHpcesOK4m8EEmjLQPAlsT+Q1T/B2vwATA09FCGDz/LTQ kAGKEsmcun9S6iqTNTY8POQ1LwIDAQABozcwNTASBgNVHRMBAf8ECDAGAQH/AgEAMB8GA1UdIwQY MBaAFHJJwnM0xlX0C3ZygX539IfnxrIOMA0GCSqGSIb3DQEBBAUAA4GBACzHgh8BQz4Hj+5pXKlk gvjAlq2TK8ubUNdAmoHCuqZ2nTyVQNxVweFVgnmrCimm1QzhVyg+j/m71d8Nk1iqWy2LjzPk3VgV NXZyFSm9QvRakgt3X50n25otThuCBo7SjVa7ld7bDGUF3pWeAt1TF76+/GvDGiJ6FCthvcKfXnpa MYIBsDCCAawCAQEwgcEwgbkxCzAJBgNVBAYTAlpBMRUwEwYDVQQIEwxXZXN0ZXJuIENhcGUxFDAS BgNVBAcTC0R1cmJhbnZpbGxlMRowGAYDVQQKExFUaGF3dGUgQ29uc3VsdGluZzEpMCcGA1UECxMg VGhhd3RlIFBGIFJTQSBJSyAxOTk4LjkuMTYgMTc6NTUxNjA0BgNVBAMTLVRoYXd0ZSBQZXJzb25h bCBGcmVlbWFpbCBSU0EgSXNzdWVyIDE5OTguOS4xNgIDAMa8MAkGBSsOAwIaBQCggYYwGAYJKoZI hvcNAQkDMQsGCSqGSIb3DQEHATAcBgkqhkiG9w0BCQUxDxcNOTkwNDI2MTAwMTExWjAjBgkqhkiG 9w0BCQQxFgQUefE8NCJd9Jbz8wfQcYhKFN6xjUowJwYJKoZIhvcNAQkPMRowGDANBggqhkiG9w0D AgIBKDAHBgUrDgMCHTANBgkqhkiG9w0BAQEFAARAEkvXKYmvZUOAxEKw8eovE9zcGEK8UFRNO210 9OSby7Zp5haYE7JYSiNiZkEL+CwkatqSUvXd0NmoOI9caR/pKAAAAAAAAA== ------=_NextPart_000_0108_01BE8FCB.B64598A0--