arrgh

The query is already filtered by a Product_ID. So it's not clear what value are you referring to. If you could explain why you need to determine the row number, and what db you're using we may be able to suggest a better option.

[quote]AND a.item = #URL.item#[/quote] I hope you're using MS Access .... (I can't believe I actually said that)

It can be confusing at first. Keep in mind there's different ways you can call functions, and reasons why you'd use 1 way versus another way. But let's ignore that for now and get back to your question. In order to use the function, you have to create an instance …

Not to be rude, but wasn't this already answered on like 2 other forums?

[quote](UK - dd/mm/yyyy[/quote] This is an old thread. But for anyone reading, the most important problem is the date format. CF assumes US date format by default. So while you think you're passing May 4th (4/5/2010), the date you're actually passing is April 5th! Use LS date functions to interpret …

Where are you setting the session variables? I'd also check the obvious things like is sessionManagement enabled in the application.cfm/cfc. IIRC, there used to be an issue with setting session variables and using cflocation on the same page. Don't know if it still applies though.

I haven't a clue about that one. It could be a driver issue. There was one a while back with NPE's and mySQL. But this is probably something different. Only thing I can think of is to check the server logs. Maybe they show moredetails.

Well data can't just disappear ;) So either A) You're looking at a cached page instead of the latest data OR B) The value never being updated at all OR C) something is overwriting it When you have a problem like this the first thing to do is confirm the …

You could track the previous value yourself using a variable. Simply initialize it before your query loop starts. Inside the loop perform your comparison. Then update the variable with the current value the end of each loop. [code] <cfset previousWorkshop = ""> <cfoutput query="yourQuery"> <cfif (some comparison with previousWorkshop here …

Sorry to wake the zombies (this thread is 5 years old...). But for newer CF versions use array notation, not evaluate() <cfset tmpDate = FORM["txtFFDateSet#i#"] >

... or do you want to extract the href URL for tracking purposes? Your goal wasn't clear to me either.

By default cfdirectory lists both files and subdirectories. If you're only seeing files it suggests you're using a filter or some combination of attributes that excludes them. Please post your code. [url]http://help.adobe.com/en_US/ColdFusion/9.0/CFMLRef/WSc3ff6d0ea77859461172e0811cbec22c24-7f99.html[/url]

Tacking onto a question that's over 2 years old, (and is totally unrelated to what you're asking!), is probably not the best way to get an answer ;) Open a new question ..

Any number of things could be happening. We'd need to see the rest of the code to see why it's not firing as you expect.

You mean add new options to a <select> list? Yeah, you can do that with javascript. Somethin like the code below. Just remember, javascript is cAsE sEnSiTivE ;) [code] <select id="yourSelectList" ....> <option value="1">grapes</option> <option value="2">pears</option> </select> <script type="text/javascript"> var list = document.getElementById('yourSelectList'); list.options[list.length] = new Option('strawberries', '3'); ... </script> …

[quote]form.Report_Purpose_Code[1][/quote] FORM fields aren't arrays. They're simple names. So make the <form> field names unique, and use the simple names to populate the form. ... value="#form.Report_Purpose_Code1#"> ... value="#form.Report_Purpose_Code2#">

Not sure I follow. Why do you need to pull the object into CF? You can just copy it from one table to another in a query. ie INSERT INTO Table2 ( OleObjectColumn) SELECT OleObjectColumn FROM Table1 Though I'm sure you already know MS Access and storing images is not …

The best way to answer that type of question is to try it. Did you? :)

[quote]... a pdf in cfm page. It needs to run the standard program (acrobat reader ,...) and then, open my PDF file[/quote] Just to be clear, you can't control what happens on the user's computer from the CF server. What you *can* do is serve the pdf in such a …

(What you describe would be bad in a real application) But it sounds like you have already mapped out an algorithm. So how about showing some good faith effort first. What code have you tried, what problems are you having, etc...? [quote]aww can be bothered... just gawna show[/quote] Just a …

[QUOTE]filter the results in the query[/QUOTE] It's better to filter in the db. The less info you return the better. [quote]the template just exits, and no error message is given.[/quote] That's because no actual error occurred. The .cfm template only does what you tell it to do. So unless you're …

First, I doubt you are going to get that all in one query and it is probably a mistake to try. (You'll probably end up writing it as a stored procedure). Second, what you have described is really has nothing to do with CF. It is almost entirely SQL. So …

Assuming the cfc's are okay. A few things to try separately for grins: (Make sure your test page has only the cfselect code, nothing else) 1) Use different values for the select "name" and "id" 2) Use the element "ID" instead of "name" in the bind 3) Use a fully …

First ... that's a lotta' code. But from a quick glance, my question is where is this component called/instantiated? I'm assuming session management is properly enabled, yes? [quote] <cfset session.anuser = anuser/> </cffunction> </cfcomponent> [/quote] That's kindof breaking encapsulation though..

[QUOTE=fatt;1194047]hi i'm working on airline resrsvation system and i have no idea to make the design for it i need helping please[/QUOTE] Ha ha. Answer: Hire a developer that does know how to design it for you.

[QUOTE]The Code above queries a cfc and returns the results to the second cfselect. My question would be how to return the result to a cfinput box? Is that even possible. [/QUOTE] It doesn't make much sense to return _multiple_ results to a cfinput box. Perhaps you're thinking of something …

[quote]Does a query have to be set up differently when it is a query of query?[/quote] Yes. You can't use regular CF functions inside a QoQ. It's not a database query, so it's internal syntax is very limited. Only a handful of functions are implemented. None of which will help …

The most common cause is the value you're trying to select does not exist in the values used to populate your list. For one thing, QUERY1 appears to be selecting all records from tblMain. So when you use selected="#QUERY1.TrussTypeID#" CF will use the value in the first record of the …

This same post has appeared in other forums as troll bait. Do not feed the trolls! [url]http://en.wikipedia.org/wiki/Troll_%28Internet%29[/url]

[quote]how to encrypt & decrypt an image file plz rply soon......... [/quote] It would be better to start your own question, rather than tacking on a question to a thread written in 2006...

[QUOTE=newtechie;1175344] Could not find the included template /config/_errorMap.cfm. [/QUOTE] The index.cfm page (or a page referenced by it) is trying to include another page called "_errorMap.cfm". The CF server cannot find that page. Either because the file doesn't exist or there's a missing mapping.

[QUOTE=oldnewbee;1049566] [code] <cfset total = val(#Find_Max.MaxID#) + val(#RandRange(1,10)#)> <cfoutput>val(#RandRange(1,10)#)</cfoutput><br /> <CFOUTPUT>#Find_Max.MaxID# + random number = #total#</CFOUTPUT> [/code][/QUOTE] A few tips on more elegant code 1) RandRange _always_ returns a number, so using VAL() is unnecessary. 2) The pound # signs aren't needed except in the CFOUTPUT 3) Rather than using …

I really don't have an answer for you, but the suggestion on the adobe forums seems worth investigating "...it appears as if you are routing pretty much everything through a /cazare.cfm template. Not just HTML, but images, JS and CSS as well. That is quite likely a big part of …

It is good to show some effort first. Please post what code you've tried so far. Hint: You'll need MIN(), MAX() and GROUP BY [url]http://www.w3schools.com/SQl/sql_func_max.asp[/url] [url]http://www.w3schools.com/SQl/sql_func_min.asp[/url] [url]http://www.w3schools.com/SQl/sql_groupby.asp[/url]

No offense but that query is terribly inefficient. Yes, you can do this the long way (with CF code). But most db's have far more efficient ways to calculate sums for a set of 7 values.

I am not sure what you're asking here. Are you asking how to perform some validation on the client side (javascript), how to save the information to a database, or something else?

You would have to test it out, but it seems like you need to track 3 things: 1) the number of consecutive bad logins 2) the date and time of the last bad login 3) a boolean flag indicating whether the user is permanently locked out When a user attempts …

[QUOTE=cheapterp;941469]The text field values need to be stored using [icode]#ListGetAt(FORM.txtValue, getIDs.CurrentRow)#[/icode] instead of just 'FORM.txtValue'[/QUOTE] That is not a good idea. If the form field contains comma's the script will error out. Better to keep the fields separate by dynamically naming them txtValue1, txtValue2, etc...

[QUOTE=pbfiddler;841663]I've installed coldfusion and its server. I have two major questions and am completely new to CF. 1. I copied a folder from our website (our hosting company put it together for us) into the wwwroot folder. I am able to access only one of the pages of that folder--the …

As mentioned on your other threads, you need to provide more information ;-) Like a code and image sample, an error message, etc..

Take a look at the documentation for cfquery and cfoutput. The examples are very easy to understand: [url]http://livedocs.adobe.com/coldfusion/8/htmldocs/Tags_m-o_16.html[/url]

Care to share? ;-)

[QUOTE=dgotti007;770755]I am interested in finding out how I can build a website using Coldfusion and an excel spreadsheet. I used to work for a company that did this and i am now looking to see how to do it. No geekspeak here: I know that the Coldfusion would take the …

[quote]Data Source cant be found [/quote] It sounds like you are just using the wrong datasource name. Ask your host. 1) Did they create a datasource for you. If not, ask them to create one 2) If they have created one already, what is the name of the datasource? You …

See my response on this thread [url]http://www.daniweb.com/forums/thread175062.html[/url]

[QUOTE=jedimatt;788564] <group1> <value="100"> <-- This value is in a table <value=""> <--The null ones are not in a table <value=""> <value=""> We always no how many rows to return in each group This formatted data is used for xml graphing output. [/QUOTE] What do you mean not in the table? …

I have not done it in a while, but the other server has to be accessible to the account CF is running under. For example, if the other server is set up as a mapped drive, the ColdFusion user account must have permission to access that drive. IIRC, the typical …

Is that a double quote or two single quotes? What syntax are you using to insert the encrypted string into the database? Side notes: Since I don't work with cc's I am curious... is it a good idea to actually display the full credit card number on the web page? …

Access 2007 is not supported [url]http://blog.crankybit.com/msaccess2007-and-cf8/[/url]

[quote]what happen is after the execution half of the data transfer successfully but during the process i face this problem Error Occurred While Processing Request 50[/quote] That is just the error header. What is the rest of the error message?