Web Wiz - Green Windows Web Hosting
Web Wiz Homepage Search Web Wiz

  New Posts New Posts RSS Feed - problem guys.........
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

problem guys.........
 Post Reply Post Reply
Author
  Topic Search Topic Search  Topic Options Topic Options
farrukh View Drop Down
Groupie
Groupie
Avatar

Joined: 10 May 2002
Location: Pakistan
Status: Offline
Points: 147 		Post Options Post Options   Thanks (0) Thanks(0)   Quote farrukh Quote  Post ReplyReply Direct Link To This Post Topic: problem guys.........
    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
Back to Top
Gullanian View Drop Down
Senior Member
Senior Member
Avatar

Joined: 04 January 2002
Location: England
Status: Offline
Points: 4373 		Post Options Post Options   Thanks (0) Thanks(0)   Quote Gullanian Quote  Post ReplyReply Direct Link To This Post 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
Back to Top
Bullschmidt View Drop Down
Groupie
Groupie


Joined: 31 May 2003
Location: United States
Status: Offline
Points: 72 		Post Options Post Options   Thanks (0) Thanks(0)   Quote Bullschmidt Quote  Post ReplyReply Direct Link To This Post 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
Classic ASP Design Tips, ASP Web Database Sample (Freely Downloadable)
Back to Top
farrukh View Drop Down
Groupie
Groupie
Avatar

Joined: 10 May 2002
Location: Pakistan
Status: Offline
Points: 147 		Post Options Post Options   Thanks (0) Thanks(0)   Quote farrukh Quote  Post ReplyReply Direct Link To This Post 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
Back to Top
Scotty32 View Drop Down
Moderator Group
Moderator Group


Joined: 30 November 2002
Location: Manchester, UK
Status: Offline
Points: 1682 		Post Options Post Options   Thanks (0) Thanks(0)   Quote Scotty32 Quote  Post ReplyReply Direct Link To This Post 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
Back to Top
ljamal View Drop Down
Mod Builder Group
Mod Builder Group


Joined: 16 April 2003
Status: Offline
Points: 888 		Post Options Post Options   Thanks (0) Thanks(0)   Quote ljamal Quote  Post ReplyReply Direct Link To This Post 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

L. Jamal Inc : Web/ Print Design and ASP Programming
Back to Top
 Post Reply Post Reply

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 12.08
Copyright ©2001-2026 Web Wiz Ltd.

Become a Fan on Facebook Follow us on X Connect with us on LinkedIn Web Wiz Blogs
About Web Wiz | Contact Web Wiz | Terms & Conditions | Cookies | Privacy Notice

Web Wiz is the trading name of Web Wiz Ltd. Company registration No. 05977755. Registered in England and Wales.
Registered office: Web Wiz Ltd, Unit 18, The Glenmore Centre, Fancy Road, Poole, Dorset, BH12 4FB, UK.

Prices exclude VAT at 20% unless otherwise stated. VAT No. GB988999105 - $, € prices shown as a guideline only.

Copyright ©2001-2026 Web Wiz Ltd. All rights reserved.