Search results for query: *

Thanks alot guys, I'm working on it now.

...where i select. If SC ="morethan1" THEN Dim sentencewords aWords = split(SearchText, " ") 'Open our recordset SQL = "SELECT * from advert WHERE (((table.title) = '%" & awords & "%')) OR (((table.bf) = '%" & SearchText & "%')) OR (((table.type) = '%" & awords & "%'));"...

yes thanyou.

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

Thats tremendous, many thanks.

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

I still get this error message, I'm going to sleep now, thanks for the idea i will have a look in the morning. Very much appreciate your help, i've spent all day messing round with it. Microsoft VBScript runtime error '800a01b6' Object doesn't support this property or method: 'Open'...

...email URL user_mail = Request.QueryString("email") auth_code = Request.QueryString("activate") auth_int = CLng(auth_code) %> <% check = "SELECT * FROM users WHERE random_auth ="&auth_int objConn.Execute check If objConn.check.EOF Then (**THE ERROR IS HERE, **) authenticate = "UPDATE users...

Nice idea, I am going to try this.

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

Many Thanks for your help guys you have opended my mind to this and i tried it both ways and it works great.

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

Magic - added this line at the end. Many thanks for your help. I would not have got this far otherwise! And i've just found out there is a custom tag available for this!!! aahh. It might be worth installing. added this line at the bottom. <input type=&quot;hidden&quot; name=&quot;man_id2&quot...

...<CFIF not IsDefined('url.man_id')> <CFSET url.man_id = #man_id#> </CFIF> <cfquery datasource=&quot;lvl&quot; name=&quot;cars&quot;> Select * from dt_models </cfquery> <cfquery datasource=&quot;lvl&quot; name=&quot;manufacturers&quot;> Select * from dt_manufacturers </cfquery> <!-- Edit...

Yes i sorted this, i am having real trouble posting the manufacturer id into the database, i have set up a param variable and tried to pass it between forms but it doesn't want to know. I get the error message &quot; 'manufacturer_id' is undefined in 'form1.man_id'. I have tried variations but...

Many Thanks, there were a few problems at first but it works now! One thing when I select a manufacturer the model comes up fine except the manufacturer resorts back to the original on the display. How can i make it stay on the chosen manufactuer? Many Thanks

You gave me real room for thought, cheers mate - igot it working after a few changes....select count(*) as hits, page , page_id ,dayofmonth(datetime) as theday , month(datetime) as themonth , year(datetime) as theyear , news_subject ,news_frontpage from...

...datetime.... I've been looking along these lines but it still does the same! Select date_format(datetime,&quot;%d %b %y&quot;) as look ,count(*) as hits,news_subject,news_frontpage, page_id from usertrack,news_items Where page= &quot;/news_article.cfm&quot; And month(usertrack.datetime)...