Problem Adding Columns to multiple datasources?

[UpstateWeb]

I am using 6.1 updated, MS Access 2003, Windows Webserver 2003. Can anyone see
a problem with my code. I am trying to find a better way to update columns in
multiple datasources:

<cfset VARIABLES.thislist = "tableone, tabletwo, tablethree, tablefour">
<cfloop index="ThisIndex" list="#VARIABLES.thislist#">
<cfoutput>#ThisIndex#</cfoutput>
<cfquery name="testServices" datasource="#ThisIndex#">
SELECT * FROM Services
</cfquery>
<cfoutput>#testServices.ColumnList#</cfoutput>
<cfif
ListContainsNoCase("#testServices.ColumnList#","do cumentFileName")>#ThisIndex
already has formfield<cfelse>
<cfquery datasource="#ThisIndex#">
ALTER TABLE Services ADD COLUMN documentFileName text(255) NULL;
</cfquery>
</cfif>
</cfloop>

Thanks in advance,

Rock Moore

[Dan Bracuk]

Take away the spaces following the commas in you thislist variable.

Originally posted by: UpstateWeb
I am using 6.1 updated, MS Access 2003, Windows Webserver 2003. Can anyone see
a problem with my code. I am trying to find a better way to update columns in
multiple datasources:

<cfset VARIABLES.thislist = "tableone, tabletwo, tablethree, tablefour">
<cfloop index="ThisIndex" list="#VARIABLES.thislist#">
<cfoutput>#ThisIndex#</cfoutput>
<cfquery name="testServices" datasource="#ThisIndex#">
SELECT * FROM Services
</cfquery>
<cfoutput>#testServices.ColumnList#</cfoutput>
<cfif
ListContainsNoCase("#testServices.ColumnList#","do cumentFileName")>#ThisIndex
already has formfield<cfelse>
<cfquery datasource="#ThisIndex#">
ALTER TABLE Services ADD COLUMN documentFileName text(255) NULL;
</cfquery>
</cfif>
</cfloop>

Thanks in advance,

Rock Moore

[UpstateWeb]

OK. I feel like an idiot. I have had spaces before, i think? Did 4.5 allow spaces?

Thanks,

That worked!

Rock Moore

[Dan Bracuk]

You can have spaces. They just get included as part of the list element, no matter where they appear.