Classic ASP Discussion - problem guys.........

Print Page | Close Window

problem guys.........

Printed From: Web Wiz Forums
Category: General Discussion
Forum Name: Classic ASP Discussion
Forum Description: Discussion on Active Server Pages (Classic ASP).
URL: https://forums.webwiz.net/forum_posts.asp?TID=3216
Printed Date: 29 March 2026 at 5:01pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: problem guys.........

Posted By: farrukh
Subject: problem guys.........
Date Posted: 02 June 2003 at 3:17pm

i have a problem and the problem isthat
when i post a contents in my site by using
Content Name dafsd'fasdfs'dfasd
Description dfjasdf'asd'fasd'fja'sdjf'asdf'asdf'd''
and so on........

and then i m getting an error because of this sign '
someone tell me y this is happening

and another thing is that
how i can leave blank in the numeric field in the database by submitting the form. when i try to leave null value in Age field and submit the forum it gives an error..... yyyyyyyyyyyyyyyyyyy

waiting for replies with solutions.........

-------------
i have collected some nice avatars (37) and smileys (227) here you can download
http://www24.brinkster.com/webmastertool/download.html

Replies:

Posted By: Gullanian
Date Posted: 02 June 2003 at 7:43pm

if ur passing the details through an SQL query, single quotations break it up, replace it with two ' or a double quotation or nothing

also in the database, presume your using access, edit the field in design view and change allow zero length to yes, and required to no

Posted By: Bullschmidt
Date Posted: 03 June 2003 at 2:24am

As far as Nulls go you could test using the IsNull() function and change to "" before writing to the database or else modify the properties of the field in the database table to allow Nulls.

-------------
J. Paul Schmidt, Freelance ASP Web Developer
www.Bullschmidt.com - www.Bullschmidt.com
Classic ASP Design Tips, ASP Web Database Sample (Freely Downloadable)

Posted By: farrukh
Date Posted: 03 June 2003 at 5:31am

also in the database, presume your using access, edit the field in design view and change allow zero length to yes, and required to no

there is no Change allow zero coloumn in the design view in numeric type of fields. I found it in a text type field........

-------------
i have collected some nice avatars (37) and smileys (227) here you can download
http://www24.brinkster.com/webmastertool/download.html

Posted By: Scotty32
Date Posted: 03 June 2003 at 7:37am

well i wouldnt of thought the "Numeric" would allow "Zero Length" as its ment to have a number in it... so for the "null" it would be "0"

if you want it to be zero length id use the "text" type

Posted By: ljamal
Date Posted: 03 June 2003 at 9:49am

I created a function to process all string variables before using them in a SQL statement. Basically it replaces the single quote with 2 single quotes and checks for null and/or zero length strings and replaced them with null. Upon completion if the string is not null is also wraps it in single quotes. It's a great time saver.

-------------
L. Jamal Walton

http://www.ljamal.com/" rel="nofollow - L. Jamal Inc : Web/ Print Design and ASP Programming