Search results for query: *

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

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

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

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

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

Hi, I have messed round with this to no avail. I don't know what i'm doing wrong am i not declaring a variable somewhere? The strange thing is man_id is passed as a variable correctly in the first form as it says it in the server variables debugging info. But when i click the submit button it...

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

It doesn't seem to like it? error 1064 error near 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=...