Recent content by dv8er88

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...