RE: [mv] In-line SQL Search Results Stuff

["Cameron B. Prince" <info@internetexpertsllc.com>]

******    message to minivend-users from "Cameron B. Prince" <info@InternetExpertsLLC.com>     ******

You can get the match number by using something like:

		[query
		list=1
		st=db
		sql=|
		select count(*) from tablename where bla bla bla
		|
		]
		[sql-code]
		[/query]

Not sure about the more button...

Cameron

-----Original Message-----
From: owner-minivend-users@minivend.com
[mailto:owner-minivend-users@minivend.com]On Behalf Of Shawn Butler -
Blue Planet Corp
Sent: Thursday, June 22, 2000 2:47 PM
To: minivend-users@minivend.com
Subject: [mv] In-line SQL Search Results Stuff


******    message to minivend-users from Shawn Butler - Blue Planet Corp <postmaster@thetechpage.com>     ******

Hello all! 

I am using an inline SQL search like this: 

<table border=0> 
  [sql type=list query="select * from tablename where bla bla bla "] 
  <tr> 
    <td>[page [sql-code]][sql-param title]</a></td> 
    <td valign=top>[page [sql-code]]$[sql-param price]</a></td> 
  </tr> 
  [/sql] 
</table> 
             
Pretty basic. The search works just fine. I would like to add 
the number of results found, have a more button, and give an 
error if there are 0 results. I cant seem to find a list of 
the [SQL-*] tags to see what Im missing. 

I dont think I can use the [search-region] tags... 
              
Thanks for any help! 
Shawn 


-
To unsubscribe from the list, DO NOT REPLY to this message.  Instead, send
email with 'UNSUBSCRIBE minivend-users' in the body to Majordomo@minivend.com.
Archive of past messages: http://www.minivend.com/minivend/minivend-list
-
To unsubscribe from the list, DO NOT REPLY to this message.  Instead, send
email with 'UNSUBSCRIBE minivend-users' in the body to Majordomo@minivend.com.
Archive of past messages: http://www.minivend.com/minivend/minivend-list