[AccessD] OT - ASP, Build a web table on the fly

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.





More information about the AccessD mailing list