Drew Wutka
DWUTKA at Marlow.com
Mon Oct 13 11:04:26 CDT 2008
Ok, and it's Monday, that last line should be: Will return TWO records for you... ;) Drew -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Drew Wutka Sent: Monday, October 13, 2008 10:45 AM To: Access Developers discussion and problem solving Subject: Re: [AccessD] OT - ASP, Build a web table on the fly Whoops, I goofed. Sorry, last week was a long, long week for me! Anywho, the example I gave was a little off. I had it specifically for a system I am building. Here is one that works: http://www.marlow.com/sql.zip On line 21, it connects to the Northwind database that I have copied onto our webserver. You will need to change the path on that line. To try this: http://www.marlow.com/sql.asp Keep in mind, that it's using the northwind database, so: SELECT FirstName, LastName FROM Employees WHERE City="Seattle" Will return to records for you... Drew -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Reuben Cummings Sent: Friday, October 10, 2008 9:02 AM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] OT - ASP, Build a web table on the fly Thanks for the warm welcome back. Also, thanks to everyone that contributed. Now I just need to sort thru the pile o' code sent me. Reuben Cummings GFC, LLC 812.523.1017 > -----Original Message----- > From: accessd-bounces at databaseadvisors.com > [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of > Gustav Brock > Sent: Thursday, October 09, 2008 5:42 PM > To: accessd at databaseadvisors.com > Subject: Re: [AccessD] OT - ASP, Build a web table on the fly > > > Hi Reuben > > Not my area so no tricks from me, but welcome back! > > /gustav > > >>> reuben at gfconsultants.com 09-10-2008 19:49 >>> > Anyone have some code for building a table on a web page on the fly? > > I am pulling a set of data that consists of whatever records > occur in a two week period. Therefore, I do not know how > many rows there will be. I do know there will always be 4 columns. > > Therefore, I need some help creating 4 rows, or 40 rows, > depending on the data. > > Thanks. > > Reuben Cummings > GFC, LLC > 812.523.1017 > > > > -- > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com The information contained in this transmission is intended only for the person or entity to which it is addressed and may contain II-VI Proprietary and/or II-VI Business Sensitive material. If you are not the intended recipient, please contact the sender immediately and destroy the material in its entirety, whether electronic or hard copy. You are notified that any review, retransmission, copying, disclosure, dissemination, or other use of, or taking of any action in reliance upon this information by persons or entities other than the intended recipient is prohibited. -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com The information contained in this transmission is intended only for the person or entity to which it is addressed and may contain II-VI Proprietary and/or II-VI Business Sensitive material. If you are not the intended recipient, please contact the sender immediately and destroy the material in its entirety, whether electronic or hard copy. You are notified that any review, retransmission, copying, disclosure, dissemination, or other use of, or taking of any action in reliance upon this information by persons or entities other than the intended recipient is prohibited.