delete recods()

[salvatore fusto]

I've a problem with the deleteRecords(tablename,data): looking at code
it is:
<cfset var qRecords = getRecords(arguments.tablename,arguments.data)>
<cfset var out = StructNew()>
<cfoutput query="qRecords">
<cfset out = QueryRowToStruct(qRecords,CurrentRow)>
<cfset deleteRecord(arguments.tablename,out)>
</cfoutput>
but this way it does not work.
i changed:
<cfset var qRecords = getRecords(arguments.tablename,arguments.data)>
<cfset var out = StructNew()>
<cfoutput query="qRecords">
<cfset out["id"]=qRecords["id"][currentRow]>
<cfset deleteRecord(arguments.tablename,out)>
</cfoutput>

leaving only the primary key in the data structure, and it works fine:
what do you think about?
regards
salvatore

[Steve Bryant]

Salvatore,

I have to confess that it has been a long time since I have passed in
a structure with other keys besides the primary key.

Which version of DataMgr were you using?

Thanks,

Steve

> --
> You received this message because you are subscribed to the Google Groups "DataMgr" group.
> To post to this group, send email to dat...@googlegroups.com.
> To unsubscribe from this group, send email to datamgr+u...@googlegroups.com.
> For more options, visit this group at http://groups.google.com/group/datamgr?hl=en.
>
>

[Kym Kovan]

On 10/09/2010 13:02, Steve Bryant wrote:
> Salvatore,
>
> I have to confess that it has been a long time since I have passed in
> a structure with other keys besides the primary key.

We do it a lot, and bumped into a similar problem some months back IIRC.
We had to revert to a <cfquery with real SQL! :-)

--

Yours, Kym

[salvatore fusto]

Steve,
dataMgr 2.2.02
primary key is all is needed to delete a record: the more the keys
are, the more you can have a value in the data struct slightly
different fron the corrisponding field in the table.

regards
salvatore

On 10 Set, 05:02, Steve Bryant <sebto...@gmail.com> wrote:
> Salvatore,
>
> I have to confess that it has been a long time since I have passed in
> a structure with other keys besides the primary key.
>
> Which version of DataMgr were you using?
>
> Thanks,
>
> Steve
>

[salvatore fusto]

Kym,
In dataMgr you can use sql statement: imho the best way is to use the
advsql structure, or use the runSql() method.
have a look to doc.

Regards
Salvatore

[Kym Kovan]

On 10/09/2010 17:51, salvatore fusto wrote:
> Kym,
> In dataMgr you can use sql statement: imho the best way is to use the
> advsql structure, or use the runSql() method.

I can't recall what the issue was back then but it must have been very
specific as we use both advsql and runSQL() a lot.

> have a look to doc.

Don't worry, we do :-)

--

Yours,

Kym

[Steve Bryant]

OK. I will get this fixed, hopefully by the next build.

Sorry for the trouble on this,

Steve

[salvatore fusto]

do'nt worry Steve.
thanks and regards
Salvatore

On 10 Set, 16:28, Steve Bryant <sebto...@gmail.com> wrote:
> OK. I will get this fixed, hopefully by the next build.
>
> Sorry for the trouble on this,
>
> Steve
>