| ASP query with ODBC does not return any rows when row contains null date [message #76330] |
Fri, 01 March 2002 14:53  |
Bausch
Messages: 1
Registered: March 2002
|
Junior Member |
|
|
Has anyone seen has or had a problem like this.. when i run a select query through ASP pages (with ADO connection through oracle ODBC 8.0.6), if the selected row has invalid or null date, it does not return any rows and thus application get an impression that record does not exist. No errors are also genrated. Actually we are selecting from Baan tables and baan inserts a value of 1/1/-9999 in all null date fields.
Is there any workaround this problem??
Please let me know
Thanks
|
|
|
|
| Re: ASP query with ODBC does not return any rows when row contains null date [message #76331 is a reply to message #76330] |
Fri, 01 March 2002 22:55  |
ourida
Messages: 2
Registered: March 2002
|
Junior Member |
|
|
'connection
set conn=server.createobject("ADODB.connection")
conn.open "source_donnee","user","passeword"
'insert/select
set rs=server.createobject("adodb.recordset")
rs.open "select * from inscription_sem where idsem='"&nce&"' and an_sem="&y, conn '<-- connection name
if rs.eof=true then
rs.close
rs.Open "insert into inscription_sem(code_insc_sem,idsem,code_cls,an_sem,inscrit)values('"&code_insc_sem&"','"&nce&"','"&code&"','"&y&"','true')",conn
response.write "paiement valide!"
end if
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
