i have problem with my coldfusion/mysql code! Can someone help me please?
920450
u have problem with line 19....check it....better use php with mysql
1123005
A join operation uses a single SELECT statement to return a result set from multiple tables. The re are two main types of JOIN operations:\n- INNER JOIN includes in the result set only records that are present in both tables\n- OUTER JOIN includes in the result set all records in one of the tables.\n\nColdFusion does not support OUTER JOINs, nor does it support the INNER JOIN syntax. But you can use this syntax.\n\nSELECT ColumnA, ColumnB\nFROM TableA,TableB\nWHERE TableA.The_ID = TableB.The_ID;\n\nThats a normal Join within Coldfusion. What your doing is joining two tables  where the ID from tablea equals to the ID in table B
450622
Make sure ur database supports UTF 16 characters, if so u can directly store them in the db and retrive them
556872
The problem might be that the software is registered for a single use only and if you wanna use it on other computers try re-registering the software and regarding code for CFM3 try serials.ws, cracks.ws......This might help you:)
19990
Try the following tutorials:\nhttp://www.devshed.com/c/a/MySQL/Beginning-MySQL-Tutorial/\nhttp://www.php-mysql-tutorial.com/
1007349
add a hidden field\n<input type="hidden" name="num_inputs" value="how_many_inputs_you_have">\n\nthen when submitted\n$i = 1;\n$sSql = "INSERT INTO table (name, age) VALUES";\nwhile ($i < $num_inputs) {\nif ($_POST[$name.$i] != "" && $_POST[$age.$i] != "") {\n$sSql .= "('".$_POST[$name.$i]."' , '".$_POST[$age.$i]."')";\n$i++;\n}\n}\nexecute query here\n\n$name.$i would get evaluated to name1, name2 etc, and if statement checks if both of them are empty. operation .= means "stick whats on the right to whatever was in left variable"
707494
Its going to be difficult without an understanding of some basic programming. You mentioned a MySQL editor, im hoping that this is phpmyadmin, this is what I have used to create databases before. Based on what it sounds like your needs are, you might like to try find a student studying this,and ask for his/her help. The are usually itching to get their hands on something to work with. More professional services are available from sites like rentacoder (rent a coder) - google that - Alternatively look around for some basic connection string tutorials wiht mysql and php, im sure with a little tinkering and a lot of patience you might get it working.
879067
Use mySQL and secure it. Plus, once it is set up you can manipulate it so much easier.
159996
put in the exact error message in the ms knoledgebase. \nhttp://search.microsoft.com/results.aspx?mkt=en-US&setlang=en-US&q=Driver_IRQL_not_less...+error+on+win+xp
1027306
If you can connect to the database in Dreamweaver, try connecting to it with Access and see if you can modify a table or execute a query.  It's either a permissions issue with your database file, a permissions issue with the webserver that the file is on, or something quirky.  I'd suggest turning off Friendly error messages in IE 6 so it can (hopefully) give you some good feedback.  \n\nI'm a bit confused when you say "seems that all database stuff... are not working properly when viewing". So none of your select statements are returning values either? Seems like a config issue.
774525
Edit the query's SQL code ... try changing SELECT to SELECT DISTINCT and see if that gets rid of the dupes.\n\nIf that doesn't do it, then you need to either change what fields are in your query or do some "data laundry" in the table(s) where the query's data comes from.
779901
Try this, just change the database reference and set the table field name as you have:\n\n$dbname="database_name";\n$result=MYSQL($dbname,"SELECT * FROM tablename ORDER BY rand() LIMIT 70");\nwhile ($row=mysql_fetch_array($result))\n{\n$NAME = $row["NAME"];\necho "$NAME"; \n}
168991
I am assuming you are the one asking the questions.  I have found that the biggest failing database developers have is not using the resources available for code samples. \n\nQ:  Where would you turn for help with creating a stored procedure or a select statement that was erroring out?
1071667
I think u have to enter you host name, username password and the name of the database after the =>.\n\nyou can do this wich a text editor like notepad.
714857
It is mysql_num_rows... you forgot the second underscore. Secondly your elseif could probably be written as an else or if you are testing for null being false or not, just test against true and false. \n\nI can't say too much more about the elseif since I don't know what context this snippet is in, but I know it can be a bit cleaner.\n\nTry the change of mysql_num_rows and see what happens.\n\nHope it works for you!
706590
MySQL is not installed by default on Windows. If it is installed (which I don't think it is, then just take it out like any other program.\nWhat I think the problem is, is the web site you are trying to see uses MySQL on their web server and it has broken somehow. Once the web master fixes it you should be able to see the site again.
154345
I've seen several references of this error using SQL.\n\nAre you accessing a database?  If so, are you sure you JDBC linkage is right, and your SQL is correct?