Both SQL statements work correctly.
A new row is inserted and all rows are selected.
The SELECT is fine but the INSERT causes the Null pointer error.
This has started happening after switching to a new JDBC driver (for
reasons too numerous to mention here.)
The driver seems great and solves our other issues, but causes this new
one!
(I'm working with Kola on this one)
-----Original Message-----
From: Adrian Lynch [mailto:[EMAIL PROTECTED]
Sent: 21 January 2004 16:40
To: CF-Talk
Subject: RE: Null pointers error on CFMX 6.1
I'd guess it might be that request.datasource (or form.thetest) contains
something other than what it should. Is the code below exactly as you
have
it in your page?
Ade
-----Original Message-----
From: Kola Oyedeji [mailto:[EMAIL PROTECTED]
Sent: 21 January 2004 16:27
To: CF-Talk
Subject: Null pointers error on CFMX 6.1
Hi
We are using CFMX 6.1 (an upgrade from 6) and the following code:
<cfif isdefined("form.test")>
<CFQUERY NAME="q_insert" DATASOURCE="#Request.datasource#">
insert into table1 (thetest) values ('#form.thetest#')
</CFQUERY>
</cfif>
<CFQUERY NAME="q_get_all" DATASOURCE="#Request.datasource#">
select thetest from table1
</CFQUERY>
<form name="d" action="" method="post">
<textarea name="thetest" rows="20" cols="50"></textarea>
<br>
<input type="Submit">
</form>
Produces the following error:
"The system has attempted to use an undefined value, which usually
indicates a programming error, either in your code or some system code.
Null Pointers are another name for undefined values.
Produces the following error."
I have trawled through numerous archives and found numerous references
to this prior to 6.1 but none of them seem to be exactly the same as
this.
Any pointers (excuse the pun) appreciated
Thanks
Kola Oyedeji
Certified Advanced Coldfusion Developer,
ICLP London
DDI: +44 (0) 208 256 9034 (Ex.2204)
www.iclployalty.com
_____
_____
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
