RE: loops, queries, ug...

2000-12-08 Thread Bryan Love
ginal Message- From: Andres [mailto:[EMAIL PROTECTED]] Sent: Friday, December 08, 2000 9:41 AM To: CF-Talk Subject: RE: loops, queries, ug... did you try something like this SELECT * FROM subnets order by subnetid #subnetid# SELECT * FROM subne

RE: loops, queries, ug...

2000-12-08 Thread Jason Powers
. Jason Powers Fig Leaf Software 202-797-5440 -Original Message- From: Peter Benoit [mailto:[EMAIL PROTECTED]] Sent: Friday, December 08, 2000 10:23 AM To: CF-Talk Subject: loops, queries, ug... I'm confused! I have 2 tables in the same database

RE: loops, queries, ug...

2000-12-08 Thread Hayes, David
. Name other fields -Original Message- From: Peter Benoit [mailto:[EMAIL PROTECTED]] Sent: Friday, December 08, 2000 9:23 AM To: CF-Talk Subject: loops, queries, ug... I'm confused! I have 2 tables in the same database, one

Re: loops, queries, ug...

2000-12-08 Thread John Allred
rk.com>cc: Subject: loops, queries, ug... 12/08/2000 09:22

RE: loops, queries, ug...

2000-12-08 Thread Bryan Love
# #description# -Original Message- From: Peter Benoit [mailto:[EMAIL PROTECTED]] Sent: Friday, December 08, 2000 7:23 AM To: CF-Talk Subject: loops, queries, ug... I'm confused! I have 2 tables in the same database, one table has a list of subnets(subnets), and the other

RE: loops, queries, ug...

2000-12-08 Thread John Rice
>I'm not sure of the best method to do this. I tried building a query on the >subnet table, then in the of that query, loop through another >query on the subnet_info table... but it doesn't work. Any ideas for me how >to do this? My idea: subnet IP = 1

RE: loops, queries, ug...

2000-12-08 Thread Adkins, Randy
= #IPEnding# Name = #getall.boxname# Description = #Getall.Desc# -Original Message- From: Peter Benoit [mailto:[EMAIL PROTECTED]] Sent: Friday, December 08, 2000 10:23 AM To: CF-Talk Subject: loops, queries, ug... I'm confused! I h

RE: loops, queries, ug...

2000-12-08 Thread Andres
Benoit [mailto:[EMAIL PROTECTED]] Sent: Friday, December 08, 2000 10:23 AM To: CF-Talk Subject: loops, queries, ug... I'm confused! I have 2 tables in the same database, one table has a list of subnets(subnets), and the other will contain information on each subnet(subnet_info). The subnet i

loops, queries, ug...

2000-12-08 Thread Peter Benoit
I'm confused! I have 2 tables in the same database, one table has a list of subnets(subnets), and the other will contain information on each subnet(subnet_info). The subnet in the subnets table is the unique id in that table, which has a one to many relationship with the subnet in the subnet_inf