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 strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
COLD FUSION MAILING LIST SETUP
Kingjjx, The best way to save the items is to use a database. Create a db for mailing lists and set up a dsn so that cf can find the database. Create 1 table for user info, probably just email addresses and an auto_number (identity seed on sql server) id field. Next you want to create a table... -
write multiple lines to a file with single cffile statement?
The easiest way to do this without using a tmp file (which can be a serious pain in the neck, because then you have to deal with OS as well) is to concatenate your output and do ONE SINGLE WRITE, instead of looping. Instead of doing: <cfset txtoutput1 =form.field1> <cfset txtoutput2... -
Stored procedure - Error converting data type varchar to int.
Christopher, Try trimming your passed variables, maybe even a test for isnumeric on that misbehaving variable. This problem tends to occur when a variable is passed that the SQL server can not see as a numeric value (it could be getting "0 " instead of "0". You can also... -
selecting multiple records
I think the easiest way to handle this is to make the value for each check box the id (primary key) field for the current record. When the form is submitted, the checkbox field contains a list of all the records to export, so just run you query against that value [i.e. SELECT * FROM my_database...
