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



Print Page | Close Window

Forum Software by Web Wiz Forums® version 12.08 - https://www.webwizforums.com
Copyright ©2001-2026 Web Wiz Ltd. - https://www.webwiz.net