471,853 Members | 1,856 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,853 software developers and data experts.

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 2236
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
aboka
reply views Thread by aboka | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.