I.T. Discussion Community!
-Collapse +Expand
ASP Classic
Search ASP Classic Group:

Advanced
-Collapse +Expand ASP Classic Store

Prestwood eMagazine

January Edition
Subscribe now! It's Free!
Enter your email:

   ► MB LobbyASP Classic Coding Board   Print This     

ASP Classic - Handling Data Topic

  


9 Threads:

Add New ThreadRandom Thread
,

Thread 9 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.
8 months ago
3 replies. Last post:

saifullah.s
{Too Long!}
4 months ago
Nothing New Since Your Last Visit
383
Hits

Thread 8 of 9
Thread Starter  

Bryan Valencia
ASP Classic Suddenly fails
{Too Long!}
9 years ago
2 replies. Last post:

Bryan.V
Actually, after much anguish, I found that the latest MS patch had inadvertently changed my site from Low(iis) to Medium(Pooled) Setting it back did the trick. asp classic sites dont work on medium
9 years ago
Nothing New Since Your Last Visit
10593
Hits

Thread 7 of 9
Thread Starter  

khatib_b
Diplaying javascript error message from DB
{Too Long!}
9 years ago
1 Reply:

dmichael
{Too Long!}
9 years ago
Nothing New Since Your Last Visit
4836
Hits

Thread 6 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.
16 years ago
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". Eek!
15 years ago
Nothing New Since Your Last Visit
3407
Hits

Thread 5 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
16 years ago
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"
16 years ago
Nothing New Since Your Last Visit
3452
Hits

Thread 4 of 9
Thread Starter  

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
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.
16 years ago
Nothing New Since Your Last Visit
3999
Hits

Thread 3 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") ,
16 years ago
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.
16 years ago
Nothing New Since Your Last Visit
3303
Hits

Thread 2 of 9
Thread Starter  

CathyHendricks
Data Entry Forms
{Too Long!}
17 years ago
2 replies. Last post:

CathyHendricks
{Too Long!}
17 years ago
Nothing New Since Your Last Visit
3356
Hits

Thread 1 of 9
Thread Starter  

Mido
View records in table ???
Hi all ....I'm your neighborhood next door Big Grin! from delphi forum Big Grin! ... 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 ??
18 years ago
2 replies. Last post:

wpantoja
{Too Long!}
18 years ago
Nothing New Since Your Last Visit
2669
Hits

New Thread
-
   Contact Us!
 
PrestwoodBoards.com was developed and is maintainted by me. Do you have a question or suggestion? Do you see a problem? Contact me now. My goal is to build an ad-free and spam-free source of I.T. information with many contributers (ok to promote your website/company in your bio). Yes, my company Prestwood IT Solutions is mentioned in my bio which shows with every post, but you can contribute and promote your pet project too!

2,038 People Online Now!!  
Sign In to see who's online now!  Not a member? Join now. It's free!
Show more stats...


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