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 Complete Forum Thread with Replies
Sponsored Links:
Related Messages:
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
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 !
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
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
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 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 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
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
Best Method To Hide
What's the best method to hide, or not show a certain record when doing a pull from a database, as in I am pulling a list with a dozen category's and I don't what to show one of them.
View Replies !
View Related
ASP POST Method Bug
I have a demo.asp page, that can't pass hidden value "mr progrramer" to itself using POST method. Only "mr" is passed. I created a second asp file demo1.asp and passed "mr programmer" and whole string (include space b/w mr and programmer was passed successfully). The code for demo.asp is: <% name = request.Form("name") response.Write "hello " & request.Form("name") ' if name is empty then store some string with space in it ' problem is the word before space 'mr' is passed, but 'programer' is not passed if len(name)=0 then name = "mr programmer" end if %> Code:
View Replies !
View Related
POST Method
I have a .asp page that uses the post method and it works fine on my computer using iis. But when i put it on the web server (it has windows NT4) it wont work. I've read that you have to do something to allow the post method on the server. i know nothing about windows NT4 but can get access to the server. can someone please let me know what i have to do to get this to work? Just to let you know the post method is for ssending a login and pass to another page that search a database for the record. If there is another way to do this that does not show the variables in the url please let me know. i am also willing to make it so that everything is on the same page so i dont have to pass anything.
View Replies !
View Related
Renaming Method
I'm looking for a renaming method for folder objects.I have an ASP (JScript) application that I'm creating that acts as a document library. Users can upload files, create folders, etc. Most places I go to basically have: copy, delete, move, create textfile as the only methods for the folder object - NOTHING about renaming.
View Replies !
View Related
ASP Update Method
The Folowing code is not working anymore.(500 error) Set objRS = strSQL1.Execute strSQL1 = "SELECT * FROM BannerRotor where BannerID=" & cstr(BannerID) objRS.Open strSQL1, objConn , 2 , 3 , adCmdText If not (objRS.BOF and objRS.EOF) Then [ objRS.Fields("Exposures").Value =objRS.Fields("Exposures").Value + 1 objRS.update End If objRS.Close The .execute Method works fine strSQL1 = "UPDATE BannerRotor SET Exposures=Exposures+1 WHERE BannerID=" & cstr(BannerID) objConn.Execute strSQL1 W2003 + IIS6.0
View Replies !
View Related
Search Method
i have a search page script which consists of a text field and a pulldown menu. the search function using search text works but not the pulldown menu. do I have to set separate recordset for each of the search functions, one for the search using text field and another using pulldown menu?
View Replies !
View Related
Execute Method.
can i gain the two result. in an asp page which using a stored procedure with execute method. i want to execute the query and return the count value the query at the same time. is it possible and how?must i use ado? it is not possible to make it with execute method in asp.
View Replies !
View Related
MapPath Method
I am coping a file from server to local on my computer using: fso.CopyFile Server.MapPath("downloadworkfile.htm"), Server.MapPath("p:workingworkfile.htm"), true I am getting MapPath method must be a virtual path. How do I reference a virtual path?
View Replies !
View Related
GetRows Method
When querying a database, I know I can fix the no. of returned rows/results to 20 (for example) using the GetString method: myVar = objRs.GetString(, 20, , ,) What syntax do I need to use to do the same with the GetRows method: myVar = objRs.GetRows ?
View Replies !
View Related
GET Or POST Method
when we should use GET method, when we should use POST method? GET method only sends limited amount of data, and it will show the data as part of URL. POST method won't show the data as part of URL, and can send any amount of data.
View Replies !
View Related
Update Method
I use the following to update: Dim rsEdit1 Set rsEdit1 = Server.CreateObject("ADODB.Recordset") rsEdit1.ActiveConnection = MM_shop_STRING rsEdit1.Source = "SELECT * FROM products WHERE pautoid = 12" rsEdit1.CursorType = 2 rsEdit1.LockType = 3 rsEdit1.Open() rsEdit1.("authorMemo") = "TEST" *Error message from this line rsEdit1.update rsEdit1.Close() Set rsEdit1 = Nothing The problem is that I keep getting the following error message : "Microsoft VBScript compilation (0x800A03F2) Expected identifier"
View Replies !
View Related
FileExists() Method
Here is my the relevant code: <% set fs=Server.CreateObject("Scripting.FileSystemObject") If fs.FileExists("index.stm") Then CODE HERE Else CODE HERE End If %> The problem is this: fs.FileExists("index.stm") always evaluates to false, even though I'm staring at the file "index.stm" as I type. In fact, I can open the file just fine, using the OpenTextFile() method. Checking to see if the file even exists is the problem. Anybody have any ideas?
View Replies !
View Related
Post Method
I hv an asp page that allows the users to enter two dates, when they click a button i have another asp page that is opens word and shows the results in a table. in order to get the criteria i think i need to use the post method for the page that opense word. however i ahve done a search and can not see anything that properly explains this method.
View Replies !
View Related
POST Method
I'm having trouble reading data that i send to the server using ajax. The call am making in the client-side javascript is: fullProject.open("POST", url, false); fullProject.setRequestHeader('Content-Type','application/x-www-form-urlencoded'); fullProject.send('var1=' + projectData); and I want to know how to grab that data using asp. The call that I've been manipulating is <% response.write "data: " & request("var1") %> That hasn't been working, and all I've been receiving back is the string "data: ".
View Replies !
View Related
Find Current Directory
I am wondering if there is a command to determine what the current directory is. My reason for this is that i have a include file called connection.asp sat in a folder called Data. My connection.asp file holds the connection details. I need to determine whether the file calling the include is in the root folder or not. EG. if it is the root folder the location of the db will be "Data/dbMarkShop.mdb" but if it is another folder, say a Scripts folder, the location of th db would be "../Data/dbMarkShop.mdb"
View Replies !
View Related
Find Out Distance Calculator?
I am looking for a way create a distance calculator from city to city, zip to zip, so on so forth. I know this has been done many times. Does anyone have this around by any chance. Also does anyone know of a place I can get the db or text file I need for this? I know there are some floating about but haven't came across a decent one yet.
View Replies !
View Related
Find Missing Right Parenthesis!!
I keep getting an error message: missing right parenthesis and I cannot for the life of me figure out why. Please help me find the problem! It may simply be that I've been staring at the code too long and I'm missing something obvious. SELECT A.FIELD1, NVL(SELECT DISTINCT B.FIELD1FROM TABLEB BWHERE B.FIELD2=A.FIELD2AND B.FIELD3 = 1AND B.FIELD4 =(SELECT MAX(FIELD6) AS MAXFROM TABLEC CWHERE C.FIELD2 = B.FIELD7)),0)FROM TABLEA A
View Replies !
View Related
I Need To Find A File But Only Have Partial Name
I'm looking for images in my asp page. I know the path and first and last part of the filename. Example filename: A01-30420.jpg I have the A01- and the .jpeg. The ##### portion could be anything, but always numeric (sofar). The A01 is unique, i.e. there will only be one file of A01-#####.jpg I'm using fileExists object to confirm a file exists when I have the full filename but havn't been able to figure out how to get the full filename when I only have a partial. I could rename the files, i.e. drop the -##### but I'd have to do that everytime I get new ones so I'd like to work with the original filename if at all possible.
View Replies !
View Related
|
TRACKER
