Results 1 to 8 of 8

Thread: insert string

  1. Feb 16th, 2004, 04:31 AM #1
    Goh
    Goh is offline

    Thread Starter
    Fanatic Member
    Join Date
    Jan 2004
    Posts
    908

    insert string

    how do i insert a string "N.A" into a column who define as varchar datatype...i tried to use cast but cannot...need to know the right way..

    Insert into Table (xxx) Values ("N.A") ? or ?
    Reply With Quote Reply With Quote
  2. Feb 16th, 2004, 05:08 AM #2
    mendhak
    mendhak is offline
    I'm about to be a PowerPoster! mendhak's Avatar
    Join Date
    Feb 2002
    Location
    Ulaan Baator GooGoo: Frog
    Posts
    38,170

    Re: insert string

    INSERT INTO TABLE(fieldname) VALUES('N.A');

    Is it returning some sort of an error?
    Reply With Quote Reply With Quote
  3. Feb 16th, 2004, 05:40 AM #3
    Goh
    Goh is offline

    Thread Starter
    Fanatic Member
    Join Date
    Jan 2004
    Posts
    908
    the reason why i cant get the other 5 rows is because of this!!!...there are null values...so cant get!!!kakakak thanks alot
    Reply With Quote Reply With Quote
  4. Feb 16th, 2004, 05:41 AM #4
    Goh
    Goh is offline

    Thread Starter
    Fanatic Member
    Join Date
    Jan 2004
    Posts
    908
    hmm..i got error for trying that...(the one you give me..)...
    Reply With Quote Reply With Quote
  6. Feb 16th, 2004, 10:22 AM #5
    Goh
    Goh is offline

    Thread Starter
    Fanatic Member
    Join Date
    Jan 2004
    Posts
    908
    nope this wont work
    Code:
     INSERT INTO TABLE(field1,field2) VALUES('N.A',xxxx)
    Reply With Quote Reply With Quote
  7. Feb 17th, 2004, 09:49 AM #6
    mendhak
    mendhak is offline
    I'm about to be a PowerPoster! mendhak's Avatar
    Join Date
    Feb 2002
    Location
    Ulaan Baator GooGoo: Frog
    Posts
    38,170
    What's the error, and what is xxxx?


    kakakakka.
    Reply With Quote Reply With Quote
  8. Feb 17th, 2004, 09:54 AM #7
    Goh
    Goh is offline

    Thread Starter
    Fanatic Member
    Join Date
    Jan 2004
    Posts
    908
    thanks..no eoor already in this part...but have other bugs to resolve..
    Reply With Quote Reply With Quote
  9. Feb 17th, 2004, 09:59 AM #8
    mendhak
    mendhak is offline
    I'm about to be a PowerPoster! mendhak's Avatar
    Join Date
    Feb 2002
    Location
    Ulaan Baator GooGoo: Frog
    Posts
    38,170
    Uhm... yes.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width