Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Search Problem for "Match Atleast One of the Words"
Thanks alot guys, I'm working on it now.- maverik59
- Post #6
- Forum: Microsoft: ASP (Active Server Pages)
-
Search Problem for "Match Atleast One of the Words"
...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 & "%'));"...- maverik59
- Thread
- Replies: 5
- Forum: Microsoft: ASP (Active Server Pages)
-
Arguments are of the wrong type, Error, stuck...doomed.
yes thanyou.- maverik59
- Post #5
- Forum: Microsoft: ASP (Active Server Pages)
-
Formatting a database timestamp in asp
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- maverik59
- Thread
- Replies: 1
- Forum: Microsoft: ASP (Active Server Pages)
-
Paging through recordset results to show only 9 per page.
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...- maverik59
- Thread
- Replies: 1
- Forum: Microsoft: ASP (Active Server Pages)
-
Confused Sorting a HTML table with dynamic data
Thats tremendous, many thanks.- maverik59
- Post #3
- Forum: Microsoft: ASP (Active Server Pages)
-
Confused Sorting a HTML table with dynamic data
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>...- maverik59
- Thread
- Replies: 2
- Forum: Microsoft: ASP (Active Server Pages)
-
Arguments are of the wrong type, Error, stuck...doomed.
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'...- maverik59
- Post #3
- Forum: Microsoft: ASP (Active Server Pages)
-
Arguments are of the wrong type, Error, stuck...doomed.
...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...- maverik59
- Thread
- Replies: 5
- Forum: Microsoft: ASP (Active Server Pages)
-
User Registration + Email Validation
Nice idea, I am going to try this.- maverik59
- Post #3
- Forum: Microsoft: ASP (Active Server Pages)
-
User Registration + Email Validation
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...- maverik59
- Thread
- Replies: 2
- Forum: Microsoft: ASP (Active Server Pages)
-
Outputting a Table to Excel in Coldfusion
Many Thanks for your help guys you have opended my mind to this and i tried it both ways and it works great. -
Outputting a Table to Excel in Coldfusion
Hi, I have been searching for this on the net but have only found some really wierd examples. I have this table <table width="100%" border="1"> <tr> <td>test</td> <td>test1</td> <td>honda2</td> <td> </td> <td> </td> <td> </td> </tr> </table> and... -
Catching Errors? Redirect Page for duplicate DB entry?
Hi, I get an error message "Error Executing Database Query duplicate key error" Is it possible to catch this error or detect the error in advance and then return the text "sorry you have already entered this data previously" rather than getting the error message? any Help... -
Can CFSELECT values be determined by the first cfselect in a form?
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="hidden" name="man_id2"... -
Can CFSELECT values be determined by the first cfselect in a form?
...<CFIF not IsDefined('url.man_id')> <CFSET url.man_id = #man_id#> </CFIF> <cfquery datasource="lvl" name="cars"> Select * from dt_models </cfquery> <cfquery datasource="lvl" name="manufacturers"> Select * from dt_manufacturers </cfquery> <!-- Edit... -
Can CFSELECT values be determined by the first cfselect in a form?
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 " 'manufacturer_id' is undefined in 'form1.man_id'. I have tried variations but... -
Can CFSELECT values be determined by the first cfselect in a form?
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 -
Easy?-Can I parse a timestamp for a Date Query?..
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... -
Easy?-Can I parse a timestamp for a Date Query?..
...datetime.... I've been looking along these lines but it still does the same! Select date_format(datetime,"%d %b %y") as look ,count(*) as hits,news_subject,news_frontpage, page_id from usertrack,news_items Where page= "/news_article.cfm" And month(usertrack.datetime)...
