Search results for query: *

I think I should amend this query... but how can i amend for the same result and function? I would like to select all record in table &quot;serialrecord&quot;, if there is duplicate serial no in the &quot;loan&quot; table, then select serial no with a large value of &quot;id&quot; <cfquery...

I have a question related to grouping data I have 2 fields, id and Serial No. id is unique and Serial No can be duplicate the query like this: <cfquery name=&quot;recordcheck&quot; datasource=&quot;support&quot;> select Max(id) as tempid, Serialno from loan where Serialno IN...

Pcorreia, Can I have your tag too? thanks dy@picturesplanes.com Really thanks!

I have Class, Name and ID in database. I want to search all record under same class, so I use cfoutput query to display all the record in the same class, then, what i wanna do for the next step is to modify &quot;Class&quot; of several record in the listed result by selected checkbox . How can i...

I have two textfield in a form, say &quot; field1&quot; and &quot;field2&quot; In my case, if the user enter a product ID in &quot;field1&quot; and press enter, the relative description will called dynamically from the database and loaded in field2 at the same time . How can i do with it?

But can u give me some idea how can i do that? thanks!

I have 2 textfield in a form. If i enter a value in textfield 1 , relative value will be shown in textfield 2 from database. But the value in textfield 1 will lost. how can i keep the value in textfield 1? Thanks

What i should started to make a page for searching the result in the database with some criteria? say, I have Name, Age, Sex and Location in the database, i wanna make a page which can filter the data from the database which the user can select the searching criteria first and then the searching...

Hi all, I have some question related to frame loading. I have two page. PageA (which is a simple html page having some linking) and PageB (which is a page with iframe named &quot;newsframe&quot;). How can i do the following action? when i click on the link on PageA, then PageB is loaded in...

Hi. i am a newbies of Coldfusion i would like to ask if there is any call function like javascript in CF? the case is i want to check 3 statement, if the 1st statment is true, then will use cfmail to send a email, and then check 2nd statment, and then 3rd statement.. thanks a lot!

How can I display Chinese(Big5) Data from Access 2000 with Win2000 server?

can i assign two variable if i choose a product in a drop down box ? like if i choose Product A in drop down box, the value of product will be assigned as &quot;A&quot; and the ID No will be assigned as &quot;1&quot; and so on..!