Variable To Call A Member Of Recordset.
Lets say I have created a Recordset named MySET. And I have a value passed from a form: Request.Form.Key(1) Code:
View Replies
ADVERTISEMENT
Call Recordset Value
I want to get a value from a recordset where the recordset name is dynamic and so is the field name, such as:
"rs_" & nameVar.Fields.Item(fieldVar & "_id").value
what is the correct syntax for this?
Using A Recordset To Call Another Record Set
i have this query string and goes off and pulls off all records from the inktest fields where stock level is below min. But i also want to pull off the make of ink from another table tblmake.
the problem i have is that tbl make is not linked to inktest it goes though another table tblmodel as there is only one make ie Canon many models of printers and each model can have anything upto 4 inks, is there a way i can have another record set something like select * from tblmake or i could create a query that pulls off the ink model and make but only displays the ink and make then select * from newquery where inktestid = newquery.inktestid that should give me what i want kinda rite?? Code:
Call Subroutine By Variable Value
is it possible to call a subroutine (or a function) using variable name?
Sub a()
Response.write("sub a")
End sub
Sub b()
Response.write("sub b")
End sub
Sub c()
Response.write("sub c")
End sub
Dim subname
subname = "b"
**call subname**
'does exist something like this? or something like the javascript 'eval' ?
Recordset ASP Variable
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" .
Use Variable Inside A Recordset
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:
" Do While Not objRSZone.EOF
strSuburb = objRSZone("suburb")
strZone = objRSZone("zone")
strPostCode = objRSZone("postcode")
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.
Object Recordset Variable
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.
Read A Recordset Into A Variable So I Can Disconnect From DB And Use Results?
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?
New Member
I have this error that keeps coming up after submitting a query on a website. been working on fixing it all day and need a fresh set of eyes to help me.
Provider error '8000ffff'
Catastrophic failure
/Process.asp, line 25
i think this is line 25 in my process.asp file
str = str & " WHERE tblData.Application Like '%" & Request.Form("Application") & "%' "
If one needs the entire process.asp script to look over, let me know.
Member Login
All i want to do is create a page with member login and forum by using access database. once i get that far ill be able to figure out the rest.
View Replies View RelatedMember Area
I am trying to do is make a member area. I am setup for asp and others but what I want is it to show how many points they have in there account when they enter and then when they use some of there points it will deduct there points from there account any help on this would be great Ie: websites code or any tips.
View Replies View RelatedCheck Member Of NT Group
i can use Request.ServerVariables to check the login user. is it possible to check whether the login user is the member of the NT security group? it is because i wish to create a dynamic banner according to respective NT security group.
View Replies View RelatedMember And Staff Interface
We got two interface. Staff and member. When member login, they are brought to member's page. However, when staff login, they are also brought to member's page. This is because at Dreamweaver 8, we have specified that if login succeeds, go to member.asp.
So how do I make sure that when staff login, they go to their staff.asp.? Is it by command procedures or SQL or some kind of other function? Much help needed! Project deadline is just around the corner!!!
Member Section Of Website
i need to login to a member section of a website and get authenticate at the index.asp before i can reach tools.asp, another page i will use. I see that the member section do not use cookie. It used session.
I had tried reaching tools.asp directly (with all the variable pass in together in a url example: URL). However, it will redirect me back to index.asp ,asking me to authenticate first. Is there a way to skip index.asp and go directly to tools.asp?
Member Login For Ceylon Web Designs
I need a member login system for one of my web sites where only the members are allowed to read articles published.
View Replies View RelatedDisplay Member Name Once Session Created
I have created a session, where a user logs in using his/her email address and password.
Howver I now want to display the users name once he/she is logged in. It should be easy,
but I cant quite get my head around it.
Dynamically Pass Member Id For Affiliate Program
An affiliate program I joined gave me this link to place on my website. I'd like to track which of my members use this link. To do this, the affiliate program said that I would have to dynamically populate the "YourMember" portion of this link (see below) with my member's user id. Can anyone tell me how I can do this? Code:
View Replies View RelatedCheck Is Current User Is Member Of A Group
I need to check to see if the Current logged in user on the system
is a member of a group called CustAdmin on CustNT Domain.
If the user is, I need to allow them to have access to the following:
Code:
<br><br>
<input type=Button value = "Click To View Credit Report"
</form>
<hr>
This is a Windows 2000 network.
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?
Calling Com + Object Variable Or With Block Variable Not Set
I'm turning my application into a "DLL". Everything worked fine untill I try to do a "While" in my asp code. Then I recieve an error like this:
"Object variable or With block variable not set"
My vb code look like this.....
Passing Data From Javascript Variable To Asp Variable.
is there any way of passing a javascript variable over to a asp variable so
i can write it to my database.
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:
Convert ASP Variable To Javascript Variable
How do I convert an ASP variable to a Javascript variable?
View Replies View RelatedHow To Call Dll In ASP?
I want to write a dll using VB6/VC6 and used by ASP. Questions are:
1. what special requirements for the dll used by ASP?
2. after built dll, how to use it in ASP? Where I should
save the dll? Do I need to register the dll?
Any article/link related to my question? the sample code?
How To Call VC++ DLL From ASP?
How to call VC++ DLL from ASP? Could any1 show me the way/coding step by step?
View Replies View RelatedCan I Call A WSH From ASP?
I want to have a single script for sending emails, accessible from both
ASP pages in any virtual directory in our websites (all on the one
server), plus accessible from a number of WSH (windows scripting host
vbscript files) which are triggered by the web servers Scheduled tasks.
The script formats text and checks emails and so on.
Is this a candidate for a web service? if so, how would i write it? Is a
web service available from WSH?
Call A Dll In ASP
We have a C++ DLL that we call from VB6 program. This is how we declare the DLL in VB6:
Declare Function RefSearch Lib "csearch32.dll" (ByVal path As String, ByVal findword As String, ByVal CaseSensitive As Integer) As Integer This is how we call the DLL in VB6:
hit = RefSearch(path, SearchStr1, ChkValue). Can I call this DLL in ASP and how ?
How To Call A .asp Page?
I have two .asp pages running under different IIS authentication methods..
The first page uses Windows Authentication and gets the Logged on User from
Request.ServerVariables("User_Logon")
The second page runs under different Domain credentials and can access the
ldap directory... so I want to call it like so..
user = request.servervariables("User_Logon")
then something like --
<%
call page2.asp?theuser=" & user"
%>
where page2 runs as 'anonymous' credentials... (and Logon_User is Null)
-------
If this can't be done can I write the information to a cookie and then read
it from the other asp? How would I do that?
How Can I Call Exe From ASP Code
I just want to call two exe files from asp code.
View Replies View RelatedCall MSSQL Job Using ASP
Does anyone try before using ASP to execute JOB in MSSQL?
View Replies View RelatedUsing An Input To Call A Sub R.
I have a bummer here. I have 3 sub R. that I need to call from a input button. I set up the following line, but the script just calls them with out having the button pressed. OOOO! Any ideas?
<form method="submit" name="nreg" onsubmit="(this)" action="call readitme, call saveitme, call reduce" >
I have also used method="POST" same darn thing, script just runs the sub R. with out being pushed or cliked. UUUGGG
Call ASP Function
I have a form which checks email addresses. On submitting the form i have some JavaScript checking the format of the email address, once this has been completed successfully I would like my asp function to run. On successful completion of that I would like my form to be submitted to another page. Is this possible?
View Replies View RelatedCall Report
This may be in the wrong forum, but I'm going to give it a shot anyways. Here goes.
I have a conference report that has 24 phone lines that are available for booking. Each call can take between 1-24 lines, you can have any number of calls as long as the number of lines they take up does not go over 24.
I graphiclly represent this in a horizontal bar graph that displays the number of lines that are taken up for a particular half hour.
Problem is when a meeting takes more than a half an hour, the meeting bar fills up for that whole time without any information on the meeting.
What I would like to do is have each meeting when assigned in the DB or through an array be assigned a color and then that color appears on the graph under the time the meeting is. If there are multiple meetings (there almost always are), then the meeting that has been active the longest will be the first color bar on the graph.
To make a way too long story short. I want to have a stacked bar chart that moves colors to the front as other's leave every half hour and move new ones to the back.
If you want to look at what we have now visit URL.