I.T. Discussion Community!
Rachel Bonas -Collapse +Expand
-Collapse +Expand
rbonas
-Collapse +Expand Profile◄╣
Member Info
Member Narration

POSTS:
MB Posts (25)

Search rbonas:

Advanced
Personal Account . . .
aka51
MD



Real Name:  Rachel Bonas
Primary Role:  Coder
Title:  Graduate Student
Joined: Jul 2002 (17 years ago)
Visits: 28

Message Boards Activity

25 posts.
More...
,

Thread 6 of 6
Thread Starter or a Reply (but not last)  Group

aka51
ASP query
I am submitting a query in an ASP page. , , It is a tow piece query and I am not sure the correct process to accomplish this., First I am , , , SQL ="SELECT OAID1 FROM tblOrganization where branch_labid = "& Request("branch_labid") &";", then the valuse returned from this query i would like to use it in the next query , , , SQL ="SELECT aoemail, aofirstname, aolastname FROM tblAO where OAID1 = (tring to use the value from the previous query here)", I tried to combine the select statement as below , , SQL ="SELECT aoemail, aofirstname, aolastname FROM tblAO where OAID1 = (SELECT OAID1 FROM tblOrganization where branch_labid = "& Request("branch_labid") &" ); " but I get the , [Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 1. , , Can anyone offer some help.
Posted to MB Topic: ASP Classic Coding « ASP Classic Board
17 years ago

Paul.S
How did you solve this? Was it with the in keyword?
11 years ago
Nothing New Since Your Last Visit
3403
Hits

ASP Classic Coding

Thread 5 of 6
Thread Starter or a Reply (but not last)  Group

aka51
Help with a loop
the code below for some odd reason will not work. The values for the session variables are being assigned when a database is queried. but for some reason if the session variable is empty it goes onto the else portion of the statement, , , , if Session ("aoemail1") = "" then , strTo = strTo &"here", else , strTo= strTo & Session ("aoemail1"), strTo= strTo & ";", end if , , , if Session ("aoemail2") = "" then , strTo = strTo &"here", else , strTo= strTo & Session ("aoemail2"), strTo= strTo & ";", end if , , , if Session ("supemail2") = "" then , strTo = strTo &"here", else , strTo= strTo & Session ("supemail1") , strTo= strTo & ";", end if , , , if Session ("supemail2") = "" then , strTo = strTo &"here", else , strTo= strTo & Session ("supemail2") , end if
Posted to MB Topic: ASP Classic Coding « ASP Classic Board
16 years ago

cheddar
post the code that set's the values and the loop.
16 years ago
Nothing New Since Your Last Visit
3388
Hits

ASP Classic Coding

Thread 4 of 6
Thread Starter or a Reply (but not last)  Group

aka51
Access Macros
Does anyone know how to link an access Macro through a web browser using ASP.
Posted to MB Topic: Access VBA Programming « Access Board
16 years ago

jdschram
{Too Long!}
16 years ago
Nothing New Since Your Last Visit
3383
Hits

Microsoft Access

Thread 3 of 6
Thread Starter or a Reply (but not last)  Group

aka51
Re: Access Macros
I don't think so ? Is there is a way to export info from the access database into an excel spread sheet using strictly ASP
Posted to MB Topic: Access VBA Programming « Access Board
16 years ago
Nothing New Since Your Last Visit
2
Hits

Microsoft Access

Thread 2 of 6
Thread Starter or a Reply (but not last)  Group

aka51
Re: view table info
that is where it was then when you suggested I look into the connection string being the problem i moved it out and it worked. All my other files are using an include file, I am just a little apprehensive to mess with it again.
16 years ago
Nothing New Since Your Last Visit
2
Hits

ASP Classic Coding

Thread 1 of 6
Thread Starter or a Reply (but not last)  Group

aka51
view table info
I am using ASP and this is the code I am using, ,
, <%, dim rsmail, sql, , Sql = "SELECT "& request.form("SELECT") &" FROM "& request.form("DATABASE") &" where "& request.form("WHERE_FIELD") &" = '"& strwhere &"';", , , set rsmail = Server.CreateObject("ADODB.Recordset"), , rsmail.Open sql, db, if not rsmail.EOF then, do while not rsmail.EOF, %>, , <% Response.Write rsmail("Action") %>, , , <% Response.Write rsmail("can") %>, , , <% Response.Write rsmail("emp_name") %> , , , <%, rsmail.MoveNext, loop, end if, %> However I will recieve anerror if I try to write the info to the screen as each select statement will select different things from the database so if one of the recordset (rsmail) was not selected it will cause an error., Is there a way to write it without specificing which recordset
16 years ago

rbonas
that is where it was then when you suggested I look into the connection string being the problem i moved it out and it worked. All my other files are using an include file, I am just a little apprehensive to mess with it again.
16 years ago
Nothing New Since Your Last Visit
4155
Hits

ASP Classic Coding
More...
Follow PrestwoodBoards on: 


©1995-2019 PrestwoodBoards  [Security & Privacy]
Professional IT Services: Coding | Websites | Computer Tech