[Reply To] SQL Question

Here's one way to do it (I don't know if it is the most efficient) You just need to rename Table1 to your table name and aa_test to your datasource cfquery name=get_students datasource=aa_test dbtype=ODBC SELECT studentid,studentdetails FROM Table1 /cfquery cfloop query=get_students cfset

[Reply To] (CF 6 reliability) from Re: Memory Leak on Win2k/CMX6.1

What are other people's views on this - how many people are using MX with no problems? You wrote I suggest the user with problems with the server product, to uninstall it completely and revert to CF 5.0, until Macromedia gets its act together.While a lot was

xml file/structure parsing problem

Hi I have an xml file which I parse with soxml tag (which changes it to a structure) I then have to update a database with this. The updating is fine - apart from an images tag within each record eg IMAGES IMAGE MAINimage01.jpg/MAIN TNimage02.jpg/TN /IMAGE IMAGE MAINimage03.jpg/MAIN

inserting a list

Hi I have a list of images image01.jpg, image02.jpg, image03.jpg associated with one stock record eg 1045 I want to insert these into a table like so: 1045 - image01.jpg 1045 - image02.jpg 1045 - image03.jpg Can anyone help me with the code for this please? Seamus Seamus Campbell Boldacious

[Reply To] Re: inserting a list

multiple stock records? Matthew Walker Electric Sheep Web http://www.electricsheep.co.nz/ - Original Message - From: Boldacious Web Design [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Saturday, June 07, 2003 8:57 AM Subject: inserting a list Hi I have a list of images image01