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| 23 replies. Last post: |
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. |
| 
 4753
Hits | |
Thread 6 of 9 | | Thread Starter | | | 
Vikas Athavale | Connect Sql Server on Web Please inform me the sytax for connectring SQL server on web, , Thanksing u in advace, Vikas AThavale | 1 Reply: | 
jdschram | OLE, Set objConn= Server.CreateObject("ADODB.Connection"), objConn.Open "Provider=SQLOLEDB.1;Integrated Security=SSPI;_, PersistSecurity Info=False;Initial Catalog=_, YourDB;_Data Source=YOUR_LOCAL_SERVER_NAMEDSN, Set objConn= Server.CreateObject("ADODB.Connection"), objConn.Open "DSN=mySystemDSN;" & _ , "Uid=myUsername;" & _ , "Pwd=myPassword" |
|
 4075
Hits | |
Thread 5 of 9 | | Thread Starter | | |
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") , | 5 replies. Last post: |
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. |
|
3985
Hits | |
Thread 4 of 9 | | Thread Starter | | |
CathyHendricks | Data Entry Forms {Too Long!} |
3985
Hits | |
Thread 3 of 9 | | Thread Starter | | |
John Anderson | Remote Access Database I have read every knowledge base article Microsoft has written on the subject of connecting to a remote Access database from an Active Server Page and have done everything the articles say to do and still come up with the error:, , The Microsoft Jet database engine cannot open the file ''. It is already opened exclusively by another user, or you need permission to view its data., , I know the file is not open, so that leaves permissions as being the cause. I've given every account in the f***ing domain full control of the share and file on the file server and still no dice., , Who is making the call from the web server to the file server? Can somebody tell me that?, , My web server is Win 2k running IIS 5 and the remote Access database is on a Win 2k server that is a domain controller., , Any light anybody can shed on this would be most , appreciated. | 2 replies. Last post: | 
SANDMAN | It maynot hurt to run this too:, , http://www.microsoft.com/technet/treeview/default.asp?url=/technet/security/tools/locktool.asp , , Also run a complete virus check., , Think "Code Red" and alike, any of them that use "IIS"., , I though I had a clean system ... but still found afew of these that use "IIS".  |
|
3967
Hits | |
Thread 2 of 9 | | Thread Starter | | | 
Mido | View records in table ???Hi all ....I'm your neighborhood next door  from delphi forum  ... this my first Q here in ASP hope to get answer., My Q is that I have an MDB file and it contains one field .... and I want to view the records in many columns and rows .... so could you please help me ?? | 2 replies. Last post: | 
wpantoja | {Too Long!} |
|
3150
Hits | |
Thread 1 of 9 | | Thread Starter | | |
Yesid.B | ODBC Join tables I am attempting to join two tables through an 'INDEX' field like so:
SELECT w.LOCATION, w.BOLIN, w.DATEIN, w.LOT, w.QTY, w.UNITMEAS, w.CUSTCODE, w.WEIGHT, w.PRODUCTCODE, , w."INDEX", w.QUAR FROM wrhse AS w, items AS s , WHERE w.DATEOUT IS NULL AND s.poCode ='"+txtpoCode+"' AND w."INDEX" = s."INDEX"
However I am not getting a result.
Initially I was using the following:
sql = 'SELECT * FROM subitemsTEST.DB WHERE poCode = '"+txtpoCode+"' order by index desc'
to get the indexes and from there I would get the data from 'wrhse' having the indexes. But when I get more than 192 rows for some reason the system does not display the complete result set. Why can this be? How can I join two tables?
Thank you in advance.
| 10 replies. Last post: |
amna.s | If you need a limousine for an important occasion, such as a wedding or a client visit, you need to ensure that your service provider lives up to the expectations of the occasion. https://alternativestips.com/alternatives-of-putlocker
|
|
1713
Hits | |
 | |
ASP Classic
Print This
