Search results for query: *

1. Can I export or save as an excel File .xls directly? 2. When I export a .mer file I choose the fields i want to export and any other setting I want and it works fine, but if i close FileMaker, open it again then do an export I have to re-select all the fields and setting. Can't I save the...

Thanks to you both. It works great

Hello want to loop through a query and output a new row after 3 records. Thanks D <table width="95%" border="1" cellspacing="0" cellpadding="0"> <tr> <td>record 1</td> <td>record 3</td> <td>record 3</td> </tr> <tr> <td>record 4</td> <td>record 5</td> <td>record...

OK sorry for not being more specific. Here is the result I need and below is my table structure: Here is a link to the actual page as it works now: http://sreptiles.delcoro.com/price_list/plist.cfm One more thing, I need to output everything alphabetically with a few acceptions. Specials and...

Now I get: Unknown column 'c.name' in 'field list' Thanks

Thanks, I am trying to apply this but I'm getting this error: Unknown column 'm.name' in 'field list' Here is my code: <CFQUERY Name="get" datasource="#var_datasource#" username="#var_username#" password="#var_password#"> select m.name as cat_name , s.name as scat_name , p.name...

Hi This might be a basic question but I'm not very good with MySql. I have 3 tables cat: The Main Category scat: The Sub Category product: The Product info, cat_ID and scat_ID I need to output all product BY Main Category then sub category. Right Now I get all the records for Main Category...

Hi, I have a product in my DB named 8v-71N. I am currently using the following to search: SELECT * FROM product WHERE name like '%#form.search#%' But when a search is done with any of the following no results are found: 8v71N, 8-v71 N, 8v 71N or 8v-71 N Is there a better way?

I have a database and a lot of the info is all lower case like (8975 nw 5th ave, boca raton. fl). How can I loop through and change each of the first letters in a word to Caps? (8975 Nw 5th Ave, Boca Raton. Fl). Thanks

HI I have output a list of items from the Mysql DB. The way I normally do this is to output a new form around each record with a hidden ID a its own delete button for each. Like this: <form name="form1" method="post" action="content_sat_g_rates.cfm?action=delete"> <input name="ID"...

I Can't see file included with <cfinclude> in design view. Code: <cfinclude template="header.cfm"> In DW MX the included .cfm file would show in the design view. Any Ideas Thankx

Okay sorry for being such an amateur but I have a few questions. What you mean by open the file. Don't I need to specify the room name that I want to insert the data from in the text file. I mean how do I loop through the rows in a tab delimited file. Are there row names? And don't I need to...

I have a tab the limited flat file (.txt) If I open it in Excel I see it goes from row A to AU. I have set up a table in mySQL with row A to AU. I have successfully used PHPmyadmin's insert data from file feature and specified the delimiter as /t. It imported the data fine. But I would like...

OK I found that the CFHTTP has a redirect option to direct you to the page specified but i still is not doing so. Thanks

HI I need to post some form data to another page without the user clicking a button and then go to the page it is submitting to as if I use a regular <form> post with action = test.cfm. I have tried the following <cfhttp method="Post" url="test.cfm"> <cfhttpparam type="Formfield" value="Damon...

OK, I misunderstood. I thank you all for the time spent the help and explanations. Thanks again.

Hi, First I wanted to say thanks to cLFlaVA for spending more time helping me then coming up with sarcastic comments. Thanks so much for the help cLFlaVA. I do know there is a difference between Java and Java Script. I made a typo, it was late, Also this code is actually part of a much bigger...

Hi I don't know much about Java but I have been using the following script for Field validation and it works fine in IE. Can someone please tell me how to get this to work for both. Thanks in advance. <script> function DoSubmit() { if (document.all.bill_name.value == '') {...

I recently Upgrades to Outlook 2003 and when I go to the month view in the calender the current day (today) usually has a yellow bar across the top to usually find it at a quick glance. But mine is marked with a very light gray that is barley visible. I have looked everywhere for this option of...

Sorry I ment Dose anyone know how you use the attribute "sort" of CFDIRECTORY to sort descending?