SQL and insert problem?
468235
You need to replace any quotes (" or ') with a second quote.\n\nSo if your comment is:\n\nI really liked when he said, "Go forth, wise one."\n\nYou would change it to:\n\nI really liked when he said, ""Go forth, wise one.""\n\nThat will allow the insert to propertly insert the state into the database.  Please note that it will not have two quotes in the database.\n\nSo if you did:\n\nSELECT Comment FROM MyTable\n\nYou would see:\n\nI really liked when he said, "Go forth, wise one."
948329
It sounds like you are using a linked table that does not have a primary key. Without a primary key, I think Access looses track of which row is which, and gets this error. Even if you don't want to use a primary key, you could add a primary key column to the backend table (for example, with an auto-increment value) just for Access to use. Then you can leave that column out of your queries in Access.
682934
If you have a 1 to many relationship all you need to do is select the corresponding key and then loop to insert the rest of the records into the second table. For example. \n\nuser table\nuserid as int\nuname as varchar(50)\notherdata\nother data\n\nphonenumber table\nuserid as int\nphone as varchar(16)\n\nTo insert three phone numebrs for user John Doe you so a \nselect userid from user where name = "John Doe" ;\n\nNow that you have the userid, assuming they are in an array. \nfor i = 1 to number_of_phonerecs\n   insert into phonenumber values (varuserid,varphone(i));\nnext\n\nExcuse my SQL as it's late and this is an oversimplified example.
492653
sounds like your either entering a number that is too big or too small for a particular data type. if your using int try to switch to long and see if that works.
804616
Are you getting an error? Is the field comp_it or comp_id?\n\nwrite gsSQL to the browser and see if it is generating your select statement correctly. also, why do you have gsSQL = ""?\nRather have it as follows: gsSQL = "Select * FROM complaint WHERE comp_id = " & incmp\n\nunless you have a valid reason?!
1101440
Hi,\nI am database programmer and use MS Access and SQl and others. Give a detailed example what you exactly want to do. Then I will tell you the design. I never designed a database wrong until now, hehe.\n\nA very important tip for you! If you want later export the database to SQL do NOT use the export wizzard of Access. This wizzard does not work and cost only time. Use the Import Wizzard in SQL. This wizzard works. \n\nNice greetings\nFranky
683017
"What is my problem in database connection?"\nThe three potential problems that come to mind are:\n1. You aren't using a password and the account has a password. You need to specify a password for your MySQL account when connecting.\n2. The user does not exist.\n3. Or that user is not permitted to access the database from 'localhost'.\n\nTry using the account 'accountname'@'%', to allow access from anywhere (this is not particularly secure, but it's useful for testing purposes).\n\n\nIf you don't know anything about MySQL or SQL, you are asking in the wrong place. Try a question like "Where can I find good resources for helping me learn SQL?".
1002503
I hate the darn things. I have one in my name and it's a real pain.\n\nApplications written in SQL have a real problem with them too and usually error out if you include one.\n\n\nOther than that it's just plain lazy.
470062
Sounds like your table lacks a primary key.\n\nIf it does have a primary key, you should check the lock you are using; you're probably using an optimistic lock on a database that others are updating, while you really need to use a pessimistic lock on the records you want to modify.
935764
u get all the values from an input table or something...assign the inputs to variables..code the update button to input those variable values into the database
880176
mysqlimport does exactly that. \n\nhttp://dev.mysql.com/doc/refman/5.0/en/mysqlimport.html
716245
It sounds like there's a problem in your code, or in the database. It's hard to tell from the amount of detail given, but I'd say that the customer ID procedure isn't the issue...\n\nRawlyn.
25643
I've included some helpful links listing SQL commands.  Note that some may depend on what specific database you're using (Access, MySQL, PostgreSQL), so you should check the reference for that product.
896456
mySQL should be part of your solution.\n///
2068
Hello,\n\nLooks like you need to add a 0 to the end of the rating_sum row and the script will execute. So edit the mambo.sql file located in the SQL folder by adding a 0 at the end of the rating_sum row see below:\n\n`rating_sum` int(11) unsigned NOT NULL default '',\n\nto \n\n`rating_sum` int(11) unsigned NOT NULL default '0',\n\nI think your local MySQL install is being picky. \n\nTry it out and let me know, if that works. \n\nThanks,\n\nV
96085
Call substring first, then call encode. It looks like you are using ASP or ASP.NET. You should use bind variables so that you do not need to worry about SQL injection attacks.
195827
Some of the data you were trying to append was probably too big to fit into the fields in your database (eg. you might be trying to fit 20 characters into a 15 character field).