Search results for query: *

Hi I'm stuck. I have written some ASP to search my database but i want the user to be able to "match atleast one of the words in the database" I've put the search string into an array but have no idea how to go about putting the array into the SQL. Can anyone help? Heres the code where i...

hi, my timestamp in the database looks like so... 4/8/2004 9:22:19 PM how can i format it so it says '8/4/2004' note the month and day are the other way round as well. and also '8th April 2004 at 9:22:19 PM' Many Thanks If u can help Si

I have a small access database which returns about 100records. I would like to only display 9 results per page rather than them all, and have links the bottom for subsequent forward-back pages,how do i do this? Here is my code to display all the results. <% 'Create Record Set Object Set objRst...

Hi,I'm having trouble listing records directly next to the current record in a table. Eg <table> <%Do while Not objRst.eof %> <tr> <td><%Response.write objRst("field_1_title")%></td> <td> </td> <td> </td> </tr> <tr> <td><%Response.write objRst("field_2")%></td> <td> </td> <td> </td> </tr>...

Hi, This 'simple' script I've made is supposed to check the parameters from the url (random number) check against those in the database and then activate the users account but it won't work and i'm not sure why. Any ideas,Its been a long day.... Thanks <% DIM objConn Set objConn =...

Hi, I have a form used to register members with the appropriate server side and client side validation so users can register. I would like to validate there email. What is the best way of doing this? How do i send an email to the user with a unique registration code so that there account...

Hi, I have been searching for this on the net but have only found some really wierd examples. I have this table <table width=&quot;100%&quot; border=&quot;1&quot;> <tr> <td>test</td> <td>test1</td> <td>honda2</td> <td> </td> <td> </td> <td> </td> </tr> </table> and...

Hi, I get an error message &quot;Error Executing Database Query duplicate key error&quot; Is it possible to catch this error or detect the error in advance and then return the text &quot;sorry you have already entered this data previously&quot; rather than getting the error message? any Help...

Hi I have a time stamp looking like &quot;09/01/2003 18:45:32&quot;. All I want is to do a query based on the date. I am creating a query which tracks users views but as the time is in there it counts a 'hit' each time somebody views the page for that time, rather than the day. This means i...

Hi I have a form of manufacturers and models, i want the models drop down menu to only show the models for the manufacturer which is selected. Does this make sense? I have tried using the cfqueryparam and referring it back to the form, but this is unsuccessful as on the first loading of the...

Hi I have a query which i am using for a drop down box on a webpage. Except my query returns the same item many times. (So i have a list with repeating values). Whats the command so only 1 value will appear (not the same one) its not unique is it.......... Thanks

Hi Is it possible to create a view of the files on a server. I am new to coldfusion but have successfully created a file upload page using cffile. Using the code below taking values(file) from a form. <cffile action=&quot;upload&quot...

Hi I have a form for with the following values- venue,date, time. Is it possible to send an autoresponse confirmation mail to the submitter? These values to get stored in a database table. I have absolutely no idea. Otherwise i will do it manually. Any help much appreciated.

Hi, I have a video on 3 different servers. Is it possible for users from different locations to click on one link and it redirects them to the nearest server. - There is only one link saying &quot;click here&quot; (NOT seperate links based on location.) I don't know where to start. Any help much...

I have an odd one or am i just doing something ridiculous.Seems simple enought when there are no records that person has posted from the past week i want it to say nothing to report (its for a &quot;whatsnew&quot; section). So i've done this and it won't have it. created_by is the unique id of...

HI I have successfully setup the graphs however i have some very odd y axis values such as 19.4 , 36.2 (On the bar on the right) Is it possible to get these to round up? Or permanenlty incremement by 50 for example? Many Help Very Much Appreciated! thanks in advance.

Here's my situation I'm tracking hits to my pages and on the front page (of the tracking programme) I have an index page where there is a drop down menu asking the user to select the numebr of past days they wish to search the database. i.e. 1 day, 2days, 3days, 1 week, 1 year. I have a seperate...

Hi, I would like to perform queries which lookup data from the past week,day,month etc. Is this possible? I have a timestamp field so the data does all have a relevant date. The timestamp field is in the format &quot;09/01/2003 17:53:46&quot; The query I want to use it on is... SELECT page...

I am trying to take part of a variable, i have the code which takes the URL <cfset heading_to = URLDecode(site)> URLDecode(site) is always in the form /images/orgcharts/pic.jpg i just want the pic.jpg part, is there a way to manipulate this in CF. I have a mysql database and this heading_to then...

Hi I am counting the number of repeating recurencies of a field in a mysql database. Each field in the database i require is in the format /orgcharts/images/pic.jpeg where each pic.jpeg has a different name, how do i search and retrieve JUST the pic.jpeg I have constructed this search but this...