Recent content by maverik59

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