Having an issue trying to access a variable that is populated by a value inside a recordset that I want to use in another statement. I've included the source code below:
If frmSuburb = strSuburb Then
Response.Write "Zone for " & strSuburb & " = " & strZone & " , Postcode = " & strPostCode & "<br>"
strShipZone = strZone
Response.Write strShipZone
End If
objRSZone.MoveNext
Loop "
So what I want is to use the strShipZone variable somewhere other than this place above. But it doesnt work, as it is on the loop, if i put it outside the loop it is populated by a wrong value.
I'm trying to use a variable like a file and I do not know if it is possible, like this:
varfunc=chr(60)&chr(37)&"function addone(varint) : addone = varint + 1: End function"&chr(37)&chr(62)
Now I have a addone function inside varfunc.
The value of varfunc is <%function addone(varint) : addone = varint + 1: End function%>
Is it possible I use varfunc like a file or something to make the function active? There are some operator like a pointer to variable or somehow to eval like a code block?
I have a function that I would like to use a session variable in. However I am not getting it to work out. I was wondering if you have define global variables inside functions like you do php or if something might be causing this?
this is my sql statement and i would like to retrieve the recordset in ASP.I tried retrievin like i just to for single tables e.g. MainMenu = Reponse.write RS("M.LinkMainMenu") but it looks like I cant do it when i try to join 2 tables.
Errormessage = ADODB.Recordset (0x800A0CC1) Item cannot be found in the collection corresponding to the requested name or ordinal.
strSQL = strSQL & "Select M.LinkMainMenu from tblMainMenu M, tblSubMenu S where" strSQL = strSQL & " M.LinkMainMenu = S.LinkMainMenu Group by M.LinkMainMenu" .
Im having a few prblems with object recordset and variables. I can print data into a table using objrecordset("Type").
But when i try to assign the value to a variable, ex. variable1=objrecordset("Type") i get an invalid use of null error. If i take out the code to assign it to a variable it works fine. So my question is how can i assign the value of objrecordset("type") to variable1.
This seem to be a simple question, but I'm having no luck with Google keywords...
I have an some ASP in which I open a recordset via a connection to a MSSQL database. I don't want to keep the database connection open while I'm processing the data from the resulting recordset.
Is there a method that I can use to copy the recordset into an array (collection, etc), the close my DB connnection and finally process the data I copied from the recordset?
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?
I have a front end with all the code and a backend with some tables. Want to convert this into website database. Most probably convert the frontend into ASP. Is this the only way? Can one use the VBA code inside ASP with translating the VBA into ASP?
I need to do a loop with some criterias that depends on an earlier database query. I tried to do it this way, but it seems not to accept that the do is inside the if:
if not objrs.EOF then Do until updatearray(0) < objrs("updated") else Do While not fso.AtEndOfStream end if Blabla my repeating script here... Loop
I'm getting this error:
Microsoft VBScript compilation error '800a03fb' Expected 'Loop' /x.asp, line 46 else ^
It seems somehow that the do is "stronger" than the if statement, as it didn't even help doing it this way: Code:
I've inherited webmaster duties for a website done in ASP.NET. After much trial and error I've figured out the architecture of the site, and have a template for the area of the page that contains the content. I need to pop in a dropdown menu, nothing fancy, like the one on this Post New Thread page for "Category".
Does anyone know where I can get the syntax for one? Or does someone know ASP.NET and can write out a simple dropdown menu code for me?
I need to make a search to search our database that can be put on different customers websites. So I was planning on making the search a reusable asp.net control. But a lot of our customers websites are written is ASP. So Is it possible to call an asp.net control inside an asp page?
We need to display certain websites inside a frame on our website and I use the response.redirect command in VBScript. The problem is that some websites take over the whole browser, how can I stop this and force a website to be loaded inside a frame?
<a href="contact.asp?subject=Question about group <%=(Recordset1.Fields.Item("group_name").Value)%>">Send a message</a>
I am actually putting above info in an Access field. People would be able to send me email through a form in contact.asp and I want the subject line reflect which page they came from.
Was thinking of having an array inside a asp page. I'm rather new to this.How do I begin. my asp page should work as follows.One html page include mail adresses. We receive a lot of junk mail and I was thinking of how to avoid this. Was thinking of creating a asp page with an inout string inside the asp page. The input number should refer to the users mail adress.
We are only four people in our office, so that should be simple to manage.The html code should be like "redirect.asp?" for the first mail adress. and redirect.asp?What's the syntax inside the asp page?
I'm currently new to OO programming with Classic ASP and have been stopped dead in my tracks on the issue of validation inside classes and if I should be doing things that way. I have been using a User class and it has methods such as Save(), Update() and Delete(). Particularly with the Update() method I'm unsure if I should be validating my form(s) within the class or on the actual edit.asp page that uses the Update() method?
I have two types of edit pages; one for Admin users and one for the My Account page. On the My Account page if the user wants to change their password they have to enter their current password, a new password and then their new password again to confirm .
If an Admin user is updating that same user's info they do not have to go through those steps and they can simple just change the password by typing it in. The point here is that there are two separate cases of validation rules on two separate pages that both use the Update() method. Do you validate your forms inside your classes or outside?
I'm still learning .Net and have an ASP.Net app that I'm working on. On this particular page, I need to put a bunch of checkboxes on the side of the page, and the text for each is derived from the database. So I can't just hardcode the checkboxes. I'll have any number of them, and possibly even 0.
I am told that you use a Repeater control for this, but beyond that, am not sure what to do. Can someone show me?
i am unable to figure out some way....so pls if anyone has implemented then do suggest me. i need to have a link on clickign to which i want excel workbook to open (a previously created template) below the link in the form.
how can i do it. i find lot of info on opening excel as an application freshly. i want to open in the form itself. is it feasible or i am just wasting my time searching info for it.
I've written a script which is still trying to concated couple of messages then send an email. Those messages are a reuqest objects coming from another form as demonstrated below: Code:
There are two table in my Access database e.g. people and orders. There is a one-to-many relationship between these. At the moment I get a recordset of all the people. I put the results of this into an array (using GetRows) and close the array and set it to Nothing.
Then on the page I have a loop which goes through the array of people and for each one performs a different db search of all the order linked to that person. On the page I have got it displaying the people perfectly but for each search the RecordCount is coming out as -1. Yet, I know there are orders associated with each person.
I have a function that I'm using to loop through some db query results and put them into a table. Inside the function, I have a line to add certain values to a series of cookies (kind of like a cookie array) as such:
If I uncomment the second line, I pull my values just fine from inside the function. The problem is, if I use the exact same line to try to pull the values outside of the function, or from another page, it returns nothing. The whole reason I'm putting these values into cookies is so that I can pull this list up on another page, but I don't seem to be able to. Is there some reason that I would not be able to read a cookie that I set inside a function outside of it?
A client uploads a document (a msword .doc file) to the server, I need to search a string that document and find specific words in it (this is an Application to a School, most of them look the same, so all you can do is replace the school name in the application, but sometimes people forget to do so and get rejected for sending inappropriate application).
So I need to find in each Application possible names of other schools and alert about it.
I'm writing in ASP (I can use ASP.net as well). I DON'T HAVE ACCESS TO THE SERVER (it belongs to the hosting company, and there's no way of installing anything there).
