Home » Fusion Middleware & Colab Suite » Weblogic & Application Server » ASP query with ODBC does not return any rows when row contains null date
ASP query with ODBC does not return any rows when row contains null date [message #76330] Fri, 01 March 2002 14:53 Go to next message
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 Go to previous message
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
Previous Topic: How to ? Oracle forms server
Next Topic: Re: URGENT : start owsctl found mesg OWS-08811
Goto Forum:
  


Current Time: Sun Sep 27 02:53:05 CDT 2020