tehon3299 Posted February 9, 2003 Posted February 9, 2003 Hey - I have textboxes and I'm inserting the text from the textboxes into an SQL table. The only problem is it screws up when you put a space in any of the textboxes. How can I fix this?? Thanks Quote Thanks, Tehon
Moderators Robby Posted February 9, 2003 Moderators Posted February 9, 2003 "select * from myTable where field = '" & textbox.text.tostring & "'" Quote Visit...Bassic Software
tehon3299 Posted February 9, 2003 Author Posted February 9, 2003 I'm actually doing that but with an INSERT statement but and I have the quotes exactly the same but if there is a space in the textbox then it just doesn't do the insert statement. Any ideas? Thanks Quote Thanks, Tehon
Moderators Robby Posted February 9, 2003 Moderators Posted February 9, 2003 It shouldn't matter if it's a Select or Insert, the single quotes surrounding the string will work. I hope that the fields' data type is a string. Quote Visit...Bassic Software
tehon3299 Posted February 9, 2003 Author Posted February 9, 2003 Yeah, that works perfectly. Thanks a lot! Quote Thanks, Tehon
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.