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

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

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

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

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

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

Dose anyone know how you use the attribute "sort" of CFFILE to sort descending?

I have 2 date fields in Mysql. start_date and complete_date. How do I calculate the amount of days between them. Example: start_date is 2005-01-28 complete-date is 2005-07-28 I want to output Completion Time 6 days or 7 days what ever it is? Thanks

Put very simply. I would like to keep someone for posting and string with a word that starts with 'S' Example: Someone enters "I like to eat stake late at night." Output should say: "I like to eat late at night.

Put very simply. I would like to keep someone for posting and string with a word that starts with 'S' Example: Someone enters "I like to eat stake late at night." Output should say: "I like to eat late at night."

Hi I have a contact manager that I want to popup in a modal popup but i need to go from page to page remembering the parent window so when I close the MODAL I can insert the contact info onto the page the it was poped up from. I can't get this to work.so I am using a regular popup. This works...

Hi, My customer wants to prevent people from entering any prices in his data. He wants me to do this by not inserting any data that follow a $ up to the first space. Example: "New car $1300.00 in great condition." Should only enter: "New car in great condition." into the database. How can I...

Hi, My customer wants to prevent people from entering any prices in his data. He wants me to do this by not inserting any data that follow a $ up to the first space. Example: "New car $1300.00 in great condition." Should only enter: "New car in great condition." into the database. How can I...

I am looping and biulding a var seperated by commas. But i need to remove the last comma. Thanks

I am am setting a sort order by a drop down menu. The default is by Horse Power and it works fine. The other option is to sort by Manufacturer; if they select this option I want to sort by Manufacturer name then in HP order. But the data come out wrong the Manufacturer and HPs are mixed...