please decipher the message below into something meaningful.
thank you.
-Original Message-
From: [EMAIL PROTECTED] [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, January 21, 2003 7:19 AM
To: CF-Talk
Subject: Deleting a row from a query?
How funny the certified Macromedia
At 08:18 AM 1/21/2003, you wrote:
How funny the certified Macromedia instuctor can't suggest a query of
query, Go get a fuction? are you kidding? I'm your not my
instuctor. Being able to solve a problem quickly and simply should be the
goal here.
I really don't think that's a fair complaint.
what are you talking about? did I miss something
:-)
-Original Message-
From: [EMAIL PROTECTED] [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: 21 January 2003 12:19
To: CF-Talk
Subject: Deleting a row from a query?
How funny the certified Macromedia instuctor can't suggest a query
The question was How can I delete a row from a query?
Answer, a query is a struct of associative arrays, find the array row and
delete rows for each of the struct keys. Simon quite rightly pointed out
that there is a UDF to do this on cflib, as I also had previously mentioned.
How funny the
and then
delete that row from the structure but I'm not sure.
~Jason
-Original Message-
From: Bryan F. Hogan [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, January 21, 2003 12:49 AM
To: CF-Talk
Subject: RE: Deleting a row from a query?
CFQUERY NAME=DeleteMyRow DATASOURCE=#myDSN
This is a bit of a wild guess...
KeyRow = StructFind(YourQuery[PrimaryKey],YourValue);
for (i=1;i=ListLen(YourQuery.ColumnList;i=i+1) {
thisColumn = ListGetAt(YourQuery.ColumnList,i);
StructDelete(YourQuery[thisColumn],KeyRow);
}
Basically, I'm treating a Query as a Struct. Finding the
Nope...
suppose you have a query in memory with 100 records in it.
You want to delete record number 43 from the query and leave
all of the other's in place. How would one go about doing
this? I don't want to touch the database. I'm assuming the
best way may be to copy the query to a
head, so I've probably got something wrong
somewhere, but hope it helps.
Going home now... ;o)
Regards
Stephen
- Original Message -
From: Stephen Moretti [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Monday, January 20, 2003 6:02 PM
Subject: Re: Deleting a row from a query
monitoring, mapping reporting
www.navtrak.net
410.548.2337
-Original Message-
From: Stephen Moretti [mailto:[EMAIL PROTECTED]]
Sent: Monday, January 20, 2003 1:20 PM
To: CF-Talk
Subject: Re: Deleting a row from a query?
OK... See now, when I was writing the other email it occurred
How about something like:
cfquery name=qry1 datasource=myDB
SELECT *
FROM myTable
/cfquery
cfoutput query=qry1
#userID#br/
/cfoutput
hr
cfquery name=qry1 dbtype=query
SELECT *
FROM qry1
where userID != 'KSUH'
/cfquery
cfoutput query=qry1
#userID#br/
line)
www.figleaf.com
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Monday, January 20, 2003 14:06
To: CF-Talk
Subject: Re: Deleting a row from a query?
How about something like:
cfquery name=qry1 datasource=myDB
SELECT *
FROM myTable
way to delete
rows from the query (when the user deletes content)
and then rewrite the file in wddx format.
~Jason
-Original Message-
From: Simon Horwith [mailto:[EMAIL PROTECTED]]
Sent: Monday, January 20, 2003 2:25 PM
To: CF-Talk
Subject: RE: Deleting a row from a query?
I believe
12 matches
Mail list logo
