Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: larrylapointe
- Order by date
-
MS SQL Insert query
And a new day dawns... Not sure why, but when I added the intervening fields between PartyId and Code, the insert is working. Incidently, the second field (after PartyId) *was* a numeric....I'm not really sure why I needed to include these extra fields in the statement, but it works... Thanks...- larrylapointe
- Post #4
- Forum: PHP
-
MS SQL Insert query
Hmmm.... I have double checked the database Table that Code, Date, and Type are varchars and that PartyId is, in fact, a numeric. I have also experimented using the process of elimination to identify that this field is where the problem is. Is it possible that somehow the 101 is being cast to...- larrylapointe
- Post #3
- Forum: PHP
-
MS SQL Insert query
I am writing a PHP script to automatically import data from a text file into an MS SQL database. Unfortunately when I try to run execute the SQL Insert statment the server seems to be converting a numeric value into a varchar field... Here are the lines in php: $Query = "Insert into...- larrylapointe
- Thread
- Replies: 3
- Forum: PHP
