Re: Compare two tables

I'd probably make two separate queries, one to each database and then do a query of queries to find the data you're looking for. Koen ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get

Re: action pages

That's up to you. It goes on the page that the form posts to, usually another action page. Koen ~| Create robust enterprise, web RIAs. Upgrade to ColdFusion 8 and integrate with Adobe Flex

Re: action pages

Something like this should work: cfmail...type=html... cfloop collection=#form# item=field #field#: #form.[field]#br / /cfloop /cfmail Koen ~| ColdFusion 8 - Build next generation apps today, with easy PDF and Ajax features -

Re: Query in a function

That won't quite work...it will return all users where active=1, even if userID is specified. -- Josh You're absolutely right. WHERE (active = '1' AND #arguments.userID# = 0) OR userID = #arguments.userID# ~| Create Web

Re: Query in a function

Try this: cffunction name=getUsers returntype=query access=remote cfargument name=userID type=numeric required=false default=0 / cfset var queryUsers = / cfquery name=queryUsers datasource=#application.ds# SELECT userID, userType, userAccessLevel, userName,

Re: How images appear in the page?

Luis, Usually the way I troubleshoot these issues is to right-click on the image and check the properties. This will tell me exactly where the browser is attempting to find the image to display. Then you can check to be sure the image is actually in that location. If it is, you may have a

Re: Form strangeness

Be sure the form tag, which includes #actionpage# is within a cfoutput block. Take a look at the source of your form to be certain it's set to post to the right page. Koen ~| Create robust enterprise, web RIAs. Upgrade

Re: Conditional SQL

Try this: DECLARE @productgroupid bigint; SET @productgroupid = 5; SELECT Title, ProductID FROM aTable WHERE Stock 0 AND (m.ProductGroupID = @productgroupid AND @productgroupid 0) Koen ~| ColdFusion MX7 and Flex 2

Re: Flex barcode reader

There's software out there to help you out. I've used SiteKiosk ( http://www.sitekiosk.com/) and it was a cinch to set up the running application, what the user could/couldn't do, etc. Koen ~| Upgrade to Adobe ColdFusion MX7