469,148 Members | 1,275 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,148 developers. It's quick & easy.

Parameter value from empty text box - null or 0 length?

Hi,
I run a stored procedure with a parameter given from a text box in an access
adp. If the text box is empty then what is passed to the parameter? I can't
seem to get it to flag up as either null, or 0 length.

Any tips?
Cheers,
Chris
Jul 20 '05 #1
1 2203
Hi

NULL does is not the same as an empty string!

Do you know what value it is passing? It may be a single space? Using
profiler would show the command being executed on your server. Depending on
how you are trying to create the command being sent to SQL Server will
determine what you can do. Using the NULLIF function along with RTRIM may
solve your problem if you are using a passthrough query.

John
"Not Me" <No****@faker.fake.fa.kee> wrote in message
news:cb**********@ucsnew1.ncl.ac.uk...
Hi,
I run a stored procedure with a parameter given from a text box in an access adp. If the text box is empty then what is passed to the parameter? I can't seem to get it to flag up as either null, or 0 length.

Any tips?
Cheers,
Chris

Jul 20 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

3 posts views Thread by tornado | last post: by
2 posts views Thread by DazedAndConfused | last post: by
7 posts views Thread by =?ISO-8859-2?Q?Gregor_Kova=E8?= | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by zhoujie | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.