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.
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
Hello all,
First, I should let you know that I am not an experienced ASP coder and, honestly, don't have lots of experience with Microsoft products. I've been using Unix for more than 20 years and Linux for about 10 years. Most of my programming experience is with Perl and Python.
I just landed a new client that needs some code work on their current online training that they offer. It's written in ASP Classic and running on a Postgresql back-end. I don't have experience with ASP Classic but can pick-up on the language relatively quickly (I think). I will do the work on a Windows XP box if I have to but would prefer to do the coding one of my Linux boxes, if possible. Does anyone know if this is even possible?
Thanks for your help.
Hi there.
I need to clear groups of sessions to force-logout groups of users.
Can I get a collection of sessions at Application level and abandon them from there?
Any help much appreciated, thank you!
Craig.
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.
The following function demonstrates one technique for coding a Yes/No dropdown. It uses a for loop which can be expanded to handle more than the 3 states (Y, N, and blank).
In ASP, using ADO, you use RecordSet.AddNew to add a new record, Recordset.Update to post the record, and RecordSet.Delete to delete it. To edit a record, you open the RecordSet using an editable cursor.