Get Progress Data from ASP page syntax error.

[terrence_chan99]

I keep getting progress syntax error with this... what should be the correct syntax.(something wrong in the misc-char-4 = 'Lee' )


<%@ Language=VBScript %>
<%

set cnn = server.createobject("ADODB.Connection")
cnn.open "DSN=TESTDSN; pwd=pasword;"

set rsCustomer = server.createobject("ADODB.recordset")
rsCustomer.open "select empid, lastname, firstname from pub.customer where misc-char-4 = 'Lee' ", cnn

@>


here is the error message


Microsoft OLE DB Provider for ODBC Driverserror '80040e14'[DataDirect][ODBC PROGRESS driver][PROGRESS]Column not found/specified (7520)

 

[bulklodd]

misc-char-4

Just an idea, I'm not sure but this field can cause the problem, try to use another

 

[terrence_chan99]

The column name cannot be change as it is from a 3rd party company.

I have also tried this.

rsCustomer.open "select empid, lastname, firstname from pub.customer where ""misc-char-4"" = ""Lee"" ", cnn

But still not work.

 

[bulklodd]

rsCustomer.open "select empid, lastname, firstname from pub.customer where ""misc-char-4"" = ""Lee"" ", cnn

Did you check it without where-clause?

 

[Strider]

any solution found for this?

 

[bulklodd]

any solution found for this?

I found out you can use the following syntax:

rsCustomer.open "select empid, lastname, firstname from pub.customer where [misc-char-4] = 'Lee'

But I'm not sure about VB6, I use this syntax with VS.NET and it works.

HTH