IT SOLUTIONS
Your full service technology partner! 
Rachel Bonas -Collapse +Expand
-Collapse +Expand
rbonas
-Collapse +Expand Profile
Member Info
Member Narration

POSTS:
MB Posts (25)◄╣

Search rbonas:

Advanced
   ► MB Lobby   Print This     

aka51 Message Board Activity

  


25 Message Board Posts:

,

Thread 25 of 25
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
19 years ago

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

ASP Classic Coding

Thread 24 of 25
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
18 years ago

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

ASP Classic Coding

Thread 23 of 25
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
18 years ago

jdschram
{Too Long!}
18 years ago
Nothing New Since Your Last Visit
3639
Hits

Microsoft Access

Thread 22 of 25
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
18 years ago
Nothing New Since Your Last Visit
2
Hits

Microsoft Access

Thread 21 of 25
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.
18 years ago
Nothing New Since Your Last Visit
2
Hits

ASP Classic Coding

Thread 20 of 25
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
18 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.
18 years ago
Nothing New Since Your Last Visit
4411
Hits

ASP Classic Coding

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

aka51
Re: Viewing info selected from a table
I would love to have you look at the site but it is on an intranet, so public access is not possible. , But you do have the jist of the situation. The SQL statement is being generated dynamically, so I know that I can't hradcode rsmail as it will change with every run of the SQL statement, so I need to know how to get the info that was selected from the databse to be written out.
18 years ago
Nothing New Since Your Last Visit
2
Hits

ASP Classic Coding

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

aka51
Viewing info selected from a table
I am selecting info from an access table. the constraints for the select table are coming form another form so the information selected is never the same. Is it possible to write only the records that are selected in one command instead of writing each record individually like , , response.write rs("name"), response.write rs("age") ,
18 years ago

rbonas
I would love to have you look at the site but it is on an intranet, so public access is not possible. , But you do have the jist of the situation. The SQL statement is being generated dynamically, so I know that I can't hradcode rsmail as it will change with every run of the SQL statement, so I need to know how to get the info that was selected from the databse to be written out.
18 years ago
Nothing New Since Your Last Visit
3649
Hits

ASP Classic Coding

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

aka51
Display image
I am attempting to display an image that is stored in an access Database as an OLE Object, the code is as follows but when it rum it shows garbage caracters to the screen , , , <% , , 'Step 2: grab the picture from the database, Dim objConn, objRS, strSQL, strSQL = "SELECT image FROM test WHERE ID = 1 ;", , Set objConn = Server.CreateObject("ADODB.Connection"), objConn.Open "DSN=budget_demo", , Set objRS = Server.CreateObject("ADODB.Recordset"), objRS.Open strSQL, objConn , , %>, , , , <% , 'Step 3: Set the ContentType to image/jpg, Response.ContentType = "image/JPEG", , , 'Step 4: Use Response.BinaryWrite to output the image, Response.BinaryWrite objRS("Image"), , //Response.BinaryWrite objRS("image"), %>, , , , <%, 'Clean up..., objRS.Close, Set objRS = Nothing, , objConn.Close, Set objConn = Nothing, %>
Posted to MB Topic: ASP Classic Coding « ASP Classic Board
18 years ago
Nothing New Since Your Last Visit
2938
Hits

ASP Classic Coding

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

aka51
Auto update
I am trying to find out if it is possible to have a record created in a table once a record in another table of that same data base is created., , i.e I have a database that has 3 tables. The tblemployee is accepting data from a web site. Once the record is created for the tblemployee where the employeeid is the primary key and and auto number can I create a record in the next table tblaction inserting employeeid as a field in the new record of the tblaction.
Posted to MB Topic: Access VBA Programming « Access Board
19 years ago

jdschram
{Too Long!}
19 years ago
Nothing New Since Your Last Visit
1285
Hits

Microsoft Access

Thread 4 of 25
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
19 years ago

jdschram
The first thing to do is instead of executing the SQL, do a response.write of your sql before you execute it, followed by response.end This will show you the sql statement you are trying to execute and then ending the program before you get the ADO error... , , The next step is to get the query to work...copy paste what is shown in the response.write and try to run it in access/query analyzser/etc...or just post your sql here...
19 years ago
Nothing New Since Your Last Visit
2224
Hits

ASP Classic Coding

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

aka51
Error evaluating CHECK constraint
{Too Long!}
Posted to MB Topic: ASP Classic Coding « ASP Classic Board
19 years ago

jdschram
one other thought is that the constraint is actually on a field...like you have a field that cannot be null in the table you are trying to insert into...best bet is still to response.write your variable and work on it in access alone...that way you can be 100% sure it is not the DB that is causing the problem
19 years ago
Nothing New Since Your Last Visit
8036
Hits

ASP Classic Coding

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

aka51
Re: Error evaluating CHECK constraint
jdschram here is the code I used , , < !DOCTYPE HTML PUBLIC "-//IETF//DTD HTML//EN">, <%@ LANGUAGE="VBScript" %>, <%, lastname = Replace(Request("lastname"), "'", "''"), firstname = Replace(Request("firstname"), "'", "''"), , , , Set Connection = Server.CreateObject("ADODB.Connection"), , Connection.Mode = 3 '3 = adModeReadWrite, , Connection.Open "DSN=budget_demo", , SQLStmt = "INSERT INTO tblEmployee ( lastname, firstname) ", SQLStmt = SQLStmt & "VALUES ('" & lastname & "','" & firstname & "') ", , , Set RS = Connection.Execute(SQLStmt), %>,
Posted to MB Topic: ASP Classic Coding « ASP Classic Board
19 years ago
Nothing New Since Your Last Visit
2
Hits

ASP Classic Coding

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

aka51
Form
Does anyone have any ideas on how I can go about solving this problem. I have a form that is submitting it contents using mailto: , After the form is sent off it remains on the form page, is there a way to have it redirected.
Posted to MB Topic: JavaScript « JavaScript Board
19 years ago

jdschram
yup...using javascript a presume... this shoud be happening after the page has been submitted and the contents processed..., < !-- Begin, url=("PageToRedirectTo");, window.location=url; // End -->or < !-- Begin, url=("PageToRedirectTo");, document.write(' , // End -->
19 years ago
Nothing New Since Your Last Visit
3400
Hits

JavaScript and AJAX
Go ahead!   Use Us! Call: 916-726-5675  Or visit our new sales site: 
www.prestwood.com


©1995-2021 Prestwood IT Solutions.   [Security & Privacy]