SOT: SQL Error converting data type

[Robert Orlini]

Why would I get this SQL error : Error converting data type varchar to numeric on one filed and not another when I do a submit from a form even though they are setup the same. Both are numeric in the SQL table.

I'm entering them this way:

<CFIF getponumber.recordcount EQ 0 OR VAL(getponumber.ponumber) EQ 0>
<CFSET session.ponumber=1001>
<CFSET session.cnumber=1001>
<CFELSE>
<CFSET session.cnumber = getcnumber.cnumber + 1>
<CFSET session.ponumber = getponumber.ponumber + 1>
</CFIF>

<CFQUERY name="addPO" datasource="purchaseorders">
INSERT INTO purchaseorders
(
ponumber,
cnumber
)
VALUES (
#session.ponumber#,
#session.cnumber#
')
</cfquery>

Robert O.

---

[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

---