Automated sql-queries

[marksta80]

Hello cf-pro's

I'm quite new to coldfusion (accustomed to php), so this might be the reason
of my problems :) But let's have a look at my idea (if you want to)

I want to create a Component that creates sql statments

e.g. A method called "generateInsert" with the parameters "tableName" and an
assosiative Array (or something similar). The keys and values of the array are
not known by the component. The component should now be able to generate a SQL
Statment like this:

INSERT INTO #tableName# (...list of all array keys...) VALUES (.... list of
all array values...)

I'm able to create a component with the parameters, but how to I get e.g.
Form-Values into the needed array (or struct) and afterwards, how to i get them
out again.

I'm pretty sure I'm not the only one having this idea, so maybe you might even
have found such a component, unfortunately I haven't yet.

I'm really looking forward to your tipps
Markus

[Neculai Macarie]

> Hello cf-pro's

>
> I'm quite new to coldfusion (accustomed to php), so this might be the

reason

> of my problems :) But let's have a look at my idea (if you want to)
>
> I want to create a Component that creates sql statments
>
> e.g. A method called "generateInsert" with the parameters "tableName" and

an

> assosiative Array (or something similar). The keys and values of the array

are

> not known by the component. The component should now be able to generate a

SQL

> Statment like this:
>
> INSERT INTO #tableName# (...list of all array keys...) VALUES (.... list

of

> all array values...)
>
> I'm able to create a component with the parameters, but how to I get e.g.
> Form-Values into the needed array (or struct) and afterwards, how to i get

them

> out again.

Something like this:
<cfset fieldsToInsert = StructNew()>
<cfloop collection="#form.fieldnames#" item="field">
<cfset fieldsToInsert[field] = form[field]>
</cfloop>

#generateInsert('table', fieldsToInsert)#

Inside the generateInsert function:
<cfloop collection="#Attributes.fiieldsToInsert#" item="field">
#Attributes.fiieldsToInsert[field]#
</cfloop>

--
<mack />