Re: ASP Form processor and Oracle

I suppose you miss the ' symbol. An insert stmt must be of the kind "insert into t1 values(1,'TEXT'). If you write insert ....(1,2) oracle will convert it to '2' automatically (i think) and it will work. If you write insert....(1,A2) it cann't convert it to char. So just put the correct ' in your stmt string and it will work (I hope ;-) ) HTH Donald Zelenak wrote:

> Hi all,
>
> I have set up an Orace 8 database, and I can connect to it
> fine. IIS is running on the same machine as the database. I created a
> form to do a simple input query, but it only "sort of" works. If I
> input into the form all numbers, the form will work correctly and a
> new row will be created. If I use anything except for 0-9, it comes
> back with:
>
> Database Error: [Oracle][ODBC][Ora]ORA-00936: missing expression One
> or more form fields were empty.
>
> I had certian datatypes setup for NUMBER and some for VARCHAR2, but
> just for testing purposes I changed them all to VARCHAR2 with nulls
> allowed. I'm racking my brain on this one and I was wondering if
> someone had any ideas.
>
> Thanks,
>
> Don
Received on Fri Jun 16 2000 - 00:00:00 CDT