Recordset Find Method

I have a recordset of which when a page loads, I want to move to a specific record whose ID is equal to request("recipe"). The ID field is the primary key in the data set and is set to auto number. Is that my issue? The value on the url

http://localhost/tasty_tuscany/tuscany-italy-recipes.asp?category=3&recipe=15

for recipe is coming in as a string? I tried converting it using the Cint() method but no dice. I would think it would work like this:

Dim temp
temp = Cint(Request("recipe")

rs.Find "ID = temp"

Is that not right? Maybe I need to Cint the rs("id") first?

View Replies


ADVERTISEMENT

Using The Find Method

Based on what the user selects in a combo box I need to find the value from another column in the same record. This is what I am using:

rsPrice.movefirst
rsPrice.Find "Component='Desktop'"
If (rstPrice.BOF = True) or (rstPrice.EOF = True) Then
response.write("The Price for the Component Not Found")

else
curPrice =rsPrice("Score")
End If

I keep getting an error messages:

Microsoft OLE DB Provider for SQL Server (0x80040E29) Rowset does not support scrolling backward.

View Replies View Related

ADO Find Method

I am attempting the following for a real estate website. I want to list the agents for the office all of whom have a unique identifier with an Auto Number type. As I loop through the recordset, I also want to open another table called listings. This table has a field called agent whose value is a number and corresponds to an agent in the agent table.

If there is a listing in the listing table, I want to insert a link to "View Listings", if not, no link. I am having a hard time doing this and if someone could point me in the right direction I'd appreciate it. I tried the Find method but to no success.

View Replies View Related

Is Recordset.Find Or A Select Statement More Efficient?

i have to do a lot of searching for records in a script that i have, and i was curious whether its better to:

a) open a recordset once, then use recordset.find for each record i want to find, then close the database

or

b) open a recordset, find one record, close the recordset, open a recordset, finda second record, close the recordset, and so on

View Replies View Related

Error Type: ADODB.Recordset (0x800A0BADODB.Recordset (0x800A0BCD)

Last week, my shopping cart was still working well until I began getting the following errors 2days ago..

Error Type:

ADODB.Recordset (0x800A0BCD)
Either BOF or EOF is True, or the current record has been deleted. Requested operation requires a current record.
../order/saveorder.asp, line 157

Browser Type:

Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)

Page:
GET /main/saveorder.asp

Could you check my code below and let me know what possibly the error is?

View Replies View Related

Recordset Controlled By Another Recordset Within A Loop

I have created a forum, in which I have 3 tables:

1: Table_Forum
2: Threads
3: Replies

I have it at the moment that on the main default.asp there is a recordset that will
display all records within that table, these are a list of forums that will be available.

I have a table that will show the forum name, and the description. This table is then looped using Do while not, now what i need to do is show how many records in the Treads table are related to each forum using asp. Code:

View Replies View Related

ASP Method

I have downloaded the DiscIDCalc program from CDDB. I've used it a lot because I've written my own application for my CD collections (keeping track of the track information of each CD, track duration etc). I've already got all my CDs into the application, I'm now just going through each of the disc again just to add in the DiscID information. I do it by running the DiscIDCalc program, generating the DiscID, and then then copying and pasting this DiscID into my application and then save it.
if anyone has successfully generated the DiscID within an asp page?
Now I have to have my browser up and this DiscIDCalc program up. Just want to know if there's a way to incorporate the two together (even if it means I'm not using the DiscIDCalc anymore.). This DiscIDCalc has a documentation for its DiscIDCalcDLL.dll but it's not something that I can CreateObject with, so I'm quite clueless... I don't want to use VB to write APIs for that

View Replies View Related

Using Get Method

I use query string to search for records by using GET method. This method will generate querystring automatically by using the form name. Using search field together with drop down is fine but the problem is when i didn't enter any keyword or left the search field blank it won't display any result.

Unless I put "%" in the search field. How do I make the querystring change to "%" whenever the field is blank so that all records will be displayed.

View Replies View Related

Cant Find Folder!

However, when i opened a page on my pc the database string was:

DBFolder = path & "..mysqldataformuladata

I cant find the folder in question. Even when ftping.

Any ideas where is could be lurking?

View Replies View Related

Cannot Find DWG Files

I am trying to locate a file using the following code

Set objXMLHTTP = Server.CreateObject("MSXML2.ServerXMLHTTP")

strURL = "http://server/ApprovedAutoCAD/140-00007-01.dwg"
objXMLHTTP.Open "GET", strURL, False, "login", "password"
objXMLHTTP.Send

strReturn = objXMLHTTP.status

I get a 404 status back indicating that the file is not found, which is incorrect. I am able to locate XLS and DOC files on the same directory. Any ideas why I cannot find a DWG (Drawing) file?

View Replies View Related

Find And Replace

I am not sure if this is a question for this forum or the IIS forum but here goes. I have a dedicated server on which I am hosting about 80 websites at the moment, all of which have been created by copying a template site. All of these sites have an identical structure and are located in the same directory on the server, C:Inetpubvhosts. Several times when I have needed to make an adjustment to the sites I have to go into the remote desktop connection to the server and go site by site, copying and pasting files. For example, as each site has the same pages, ie., map.asp, sometimes I make a change to that page and have to copy it to every site. Could I write some sort of script using the FSO and execute it from one site and have it loop through each site on the server making the neccessary change(s)?

View Replies View Related

Could Not Find Path

if i use the physical path where the database is located then my code works fine
such as ("e:folderabc.mdb")

but when i use the server.mappath("abc.mdb") , i get error

View Replies View Related

Can't Find End Statement

The dreaded missing end statement
I need another set of eyes mine are about to cross.

My Error

Microsoft VBScript compilation error '800a03f6'

Expected 'End'

calendar.asp, line 289

My code:

View Replies View Related

Find Performance

We have several pages that are running very slow, is there any way to
identify which pages are taking the longest to process?

View Replies View Related

How Can I Find What Value Is In My Variable?

At first glance, the question in the subject line seems way too easy. But I
am finding some situations in my app where the value in a variable is some
sort of blank-like value, such as Null or " " or "", but I cannot tell
which.

Of course, in order to find out the value, I did a response.write, and added
a nonsense word afterward, to help make sure it is writing it out for me.

First, I tried to check for null: Code:

View Replies View Related

Best Way To Find <> NULL

How do I go about testing to see if a value is not equal to NULL? isNULL provides the opposite functionality, but all my attempts at the former return a FALSE value.

View Replies View Related

Find Referer

I want to know how to find out who is sending visitors to my site. So i obviusly need to find out who a visitors referer is.

I took a guess and thought that this is what I should use:

request.ServerVariables("HTTP_REFERER")

But that does not return anything. Any ideas guys?

View Replies View Related

Find Quoteint In Asp

can u tell me how to find the quoteint in asp

for e.g
290 / 100 = 2
I want result 2 but it gives 2.9

View Replies View Related

Find Images

where i can get very professional and sophisticated images for my web sites ( even if i have to pay for them )

View Replies View Related

Find Errors

I'm coding in classic asp and can't figure how to get IE6 to display some kind of descriptive message about code errors? I have the correct settings under ADVANCED in IE's options selected.

What bugs me is sometimes IE will report the line number and a message, and then other times it's the standard "The page can't be displayed." When you have hundreds of lines of code, how can you fight this?

View Replies View Related

Find In String

How can i count the number of times a string appears within another string.

View Replies View Related

Find Out The Count

i have 2 columns. called wintersubjects,summersubjects . the data in the columns will be 4 subjects.

maths
science
arts
social science

i want to find out the count for all of them.

View Replies View Related

Find Numbers

I want to find numbers in one comma seperated string which are not in another one. For instance if I have two strings "strString1" and "strString2 how can I find numbers in "strString1" which are not in "strString2" Example:

strString1 = "1,3,6,12"
strString2 = "1,6"

In this case the numbers I want to end up with are 3 and 12.

View Replies View Related

Cant Find Syntax

I am working on a survey and I have gotten the pages done to collect the data but now I am having trouble finding the correct syntax for displaying some of the data back to the user. I basicly need one to do this

Text on site <field1*field2*1.5> More Text on site.

and a seperate one to do this:

if field1=a then write "message one"
if field2=b then write "message two"

View Replies View Related

Find And Replace URL

I'm working on something at the moment which pulls through a url to another page if it exists. I've got that bit working.

The bit I don't know how to do (real asp beginner here) is to check if the url has http:// in it, and if it has, remove it.

View Replies View Related

UPDATE Method In ASP,SQL

i am trying top update a field in my sql database but it wont let me??? does anyone know if my syntax is correct?? I have a field called userId in the database and want to replace it with my form request. Code:

View Replies View Related

Method Not Allowed

Method Not Allowed
The requested method POST is not allowed for the URL /Database/processForm.asp.

Apache/1.3.33 Server at antonyx.freestarthost.com Port 80

i just got this error, however, i have managed to post data into my database on this server b4, why is this error comin up now, could there be a prob with my asp file??

View Replies View Related

GetString Method

When using ActiveX Combo Boxes, can you use the GetString method to populate the control? I currently am using AddItem, however, it is taking a long time to process. I know that GetString works well to improve the performance. Here is my code while using AddItem:

while not rsClient.EOF
Response.Write chr(9) & "MenuForm.lstClient.additem " & chr(34) & replace(rsClient.Fields("Client Name").value,chr(34),"'") & " [" & trim(rsClient.Fields("Client Number").Value) & "]" & chr(34) & chr(13)
rsClient.MoveNext

View Replies View Related

POST Method

Now this is a weird one. I'm having a problem with a system in development. When I post data from a form in IE 5.01 it works fine, but in IE 5.5 it refuses to post the data to the server and in IE 6 it's scatty -- works sometimes but not others. Anyone seen this before?
Edit:
By the way -- this is normal VBS/ASP running on IIS 5 on an NT server

View Replies View Related

Redirect Method

can values of variables be transfered through response.redirect onto the next page

View Replies View Related

Post Method

I have a form that ignores my form validation code. My code works if I use the post method of <%=Request.ServerVariables("SCRIPT_NAME")%>.

But, If I post the form to another .asp page, which I prefer, the code doesn't work. Do anyone have any suggestions? Here's my code.

I have a form that ignores my form validation code. My code works if I use the post method of <%=Request.ServerVariables("SCRIPT_NAME")%>. But, If I post the form to another .asp page, which I prefer, the code doesn't work. Do anyone have any suggestions? Code:

View Replies View Related

ASP HTTP GET Method

I have a service provider that's sends sms messages from clients mobile
phones to my asp page, problem is I don't know how to show the data and they
are not being helpful.
The process is simple as outlined below (instructions from service provider

Example: If you provide this: http://www.yourdomain.com/sms/sms.asp then we
will do a post via a standard HTTP GET as follow:

http://www.yourdomain.com/sms/sms.a...ISO-8859-1&udh=
How do I receive the url with the parameters in the address bar?

View Replies View Related

Email Method

I would like to know which method is best in ASP when using/coding for email via a form.

View Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved