cfloop with nested query.

Dev Shed Forums Sponsor:

June 20th, 2005, 01:33 PM

mparker1113

Contributing User

Join Date: May 2004

Posts: 254

Time spent in forums: 7 h 29 m 48 sec
Reputation Power: 5

cfloop with nested query.

Hi,

I am using cfloop to parse through a form inputted string.

I then want to run a query using the differing values from the looped parsing.

It doesn't look like the compiler is to happy with my attempts though, as it calls the asterix in my query's select statement an invalid parser construct.

Should what I have below work? (CF 4.1.xxx)

Code:

<cfloop from="1" to ="#LessorIteration#" index="i">  <!---LessorIteration = length lessor name/4: to give us num of times to look for strings 4 characters in length--->

     <cfset LessorBroken = Mid(#form.Lessor#, (i * 4), 4)> <!--- start looking for smaller versions of string ---->
                                                           <!--- NoTE: will want to implement smaller breakdown for smaller lenght strings --->
   <cfquery name="checkForDupes" datasource="Rents">
    Select * from Rents where Lessor Like '*#LessorBroken*#' and Address Like'%#form.address#%'
   </cfquery>
   <cfoutput query="checkForDupes">
   You have similar addresses at: #id#, #Lessor# <br>
   </cfoutput>
 
</cfloop>

June 20th, 2005, 02:17 PM

Bastion

Contributing User

Join Date: Oct 2004

Posts: 181

Time spent in forums: 2 Days 4 h 25 m 11 sec
Reputation Power: 5

What happens when you pull out i * 4 and assign it to a variable (i.e. <cfset midpointValue = i * 4>)? Does that throw an error?

June 20th, 2005, 03:07 PM

kiteless

Moderator

Join Date: Jun 2002

Location: Raleigh, NC

Posts: 3,689

Time spent in forums: 1 Week 4 Days 16 h 33 m 51 sec
Reputation Power: 53

Select * isn't good practice anyway. I'd select the columns by name. Still, I'm not sure why it's complaining.

__________________
Ask if you have a question, but also help answer questions that you have knowledge of! Thanks, Brian.
How to Post a Question in the Forums

June 21st, 2005, 10:07 AM

mparker1113

Contributing User

Join Date: May 2004

Posts: 254

Time spent in forums: 7 h 29 m 48 sec
Reputation Power: 5

Thank you:

I had a syntax error where I put the wild card before the ending # sign for my cf variable. Still something wrong, but at least it appears to run now.

Viewing: Dev Shed Forums > Programming Languages - More > ColdFusion Development > cfloop with nested query.

« Previous Thread | Next Thread »

Thread Tools	Search this Thread
Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode	Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts vB code is On Smilies are On [IMG] code is On HTML code is Off

View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox

Forum Jump