aka51
| Real Name: |
Rachel Bonas
|
| Primary Role: |
Coder |
| Title: |
Graduate Student
|
| Joined: |
Jul 2002 (23 years ago) |
| Visits: | 28 |
|
|
|
 Message Boards Activity
25 posts. |
|
Thread 6 of 6 | | Thread Starter or a Reply (but not last) | | | Group | 
aka51 |  ASP queryI 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.
Paul.S | How did you solve this? Was it with the in keyword? |
| 
 3795
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
cheddar | post the code that set's the values and the loop. |
|
3803
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. |
3860
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 |
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. |
2
Hits |
ASP Classic Coding | |
Thread 1 of 6 | | Thread Starter or a Reply (but not last) | | | Group |
aka51 | view table infoI 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
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. |
|
 4661
Hits |
ASP Classic Coding | | |
|
|
|
rbonas
