Is their something here that I never knew?
Moderator: General Moderators
Is their something here that I never knew?
I'm inserting a string into a varchar field. That string is essentially numbers that are delimited with a ":". Is there something about using this that I don't know about? The reason for my asking being that even though the query succeeds, this field always comes back empty.
- Christopher
- Site Administrator
- Posts: 13596
- Joined: Wed Aug 25, 2004 7:54 pm
- Location: New York, NY, US
Re: Is their something here that I never knew?
Are you sure the insert is actually succeeding?
(#10850)
- greyhoundcode
- Forum Regular
- Posts: 613
- Joined: Mon Feb 11, 2008 4:22 am
Re: Is their something here that I never knew?
Proper use of quotes within the query?
- John Cartwright
- Site Admin
- Posts: 11470
- Joined: Tue Dec 23, 2003 2:10 am
- Location: Toronto
- Contact:
Re: Is their something here that I never knew?
Also try to echo the query out before sending it to the database, as arborint suggested, it might not be what you think.
Re: Is their something here that I never knew?
arborint wrote:Are you sure the insert is actually succeeding?
Yeah, I'm sure.
Oh well. I'll keep
- jayshields
- DevNet Resident
- Posts: 1912
- Joined: Mon Aug 22, 2005 12:11 pm
- Location: Leeds/Manchester, England
Re: Is their something here that I never knew?
Post the exact query being sent to MySQL.
- Christopher
- Site Administrator
- Posts: 13596
- Joined: Wed Aug 25, 2004 7:54 pm
- Location: New York, NY, US
Re: Is their something here that I never knew?
I guess I am not clear on what "this field always comes back empty" means. The INSERT will not return any data. Are you saying that later SELECTing the record return an empty field?BDKR wrote:arborint wrote:Are you sure the insert is actually succeeding?
Yeah, I'm sure.![]()
(#10850)
Re: Is their something here that I never knew?
My bad. It's not an INSERT. It's a SELECT.arborint wrote:I guess I am not clear on what "this field always comes back empty" means. The INSERT will not return any data. Are you saying that later SELECTing the record return an empty field?BDKR wrote:arborint wrote:Are you sure the insert is actually succeeding?
Yeah, I'm sure.![]()