Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
writing an ODBC compatible cursor statement for access?
I keep track of the number of dealers in any city, and I keep a placeholder that tracks which dealer is next in the list. If there are 5 dealsers in a city, I will know which of those dealers will be next. I will pass this value (a number from 1 to 5) in a dynamic variable. I want to be able...- braedon
- Post #3
- Forum: Microsoft: Access Other topics
-
writing an ODBC compatible cursor statement for access?
I am building a client referral tool. When a potential client makes a purchase inquiry, I want to send the inquiry request to a product dealer in the city specified by the client. I have a table with a list of dealers sorted by city. One complication is that I need the referral tool to select...- braedon
- Thread
- Replies: 3
- Forum: Microsoft: Access Other topics
-
Select a single record from a recordset??
Thanks. I am using Access as my database for this project, and I am web-enabling it with Cold Fusion. After having read about cursors, I am not sure how to write the statement to do what I need it to do. Cold Fusion passes and SQL statement using ODBC to access - but I am not sure how to... -
Select a single record from a recordset??
I am building a client referral tool. When a potential client makes a purchase inquiry, I want to send the inquiry request to a product dealer in the city specified by the client. I have a table with a list of dealers sorted by city. One complication is that I need the referral tool to select... -
Select a single record from a recordset??
I am building a client referral tool. When a potential client makes a purchase inquiry, I want to send the inquiry request to a product dealer in the city specified by the client. I have a table with a list of dealers sorted by city. One complication is that I need the referral tool to select... -
Recusive loop? Or another solution
I could do it the way KevinFSI has discribed, but then I would only go one layer deep. Many of the threads already have three or four layers. Like this.... Message 1 reply 1 reply 2 reply 3 reply 4 reply 5 So to get around this I tryed building a template that called it... -
Recusive loop? Or another solution
I have made a simple discusion forum. The fields are id, poster, email, parent_id, title, desc, approved, last_modified. I would like to display the amount of times the a message has been replied to, not just the main message. I will give an example. message 1 reply 1 reply to reply 1...
