Error when entering numbrs and letters in a string

[Mark]

hello. when i enter a string of numbers via an html form to a
postgresql db, everything is fine. however, when numbers are combined
with letters in the same input box, i get the following error:

Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
Error while executing the query; ERROR: parser: parse error at or near
"da5c247"

any thoughts?

m

[Aaron Bertrand - MVP]

How about showing us the actual query you're trying to run???



"Mark" <markbudash@hotmail.com> wrote in message
news:4f210449.0308061044.69eb9fd1@posting.google.c om...

> hello. when i enter a string of numbers via an html form to a
> postgresql db, everything is fine. however, when numbers are combined
> with letters in the same input box, i get the following error:
>
> Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
> Error while executing the query; ERROR: parser: parse error at or near
> "da5c247"
>
> any thoughts?
>
> m

[John Beschler]

Sounds like your query is treating the value from the form
as a number. When you add the letters in the form it
becomes a string; however, your query is still expecting a
number. If you are going to accept strings from the form,
you must delimit them using what ever delimiter postgres
expects for strings.

John

>-----Original Message-----
>hello. when i enter a string of numbers via an html form

to a

>postgresql db, everything is fine. however, when numbers

are combined

>with letters in the same input box, i get the following

error:

>
>Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
>Error while executing the query; ERROR: parser: parse

error at or near

>"da5c247"
>
>any thoughts?
>
>m
>.
>