Re: msql access problem

[Greenman <greenman@mailgate.net>]

******    message to minivend-users from Greenman <greenman@mailgate.net>     ******

Hi filippo. 

I think everyone seems to start with the same problem. 

There are some important points to remember when you start using SQL.

1. make sure you are using the right database. 
	I started with non-product tables in my database, and got 
	exactly what you are getting now. You set your database at the
	end of the SQL statement with "base=????"

2. use new syntax. 
	I have solved 90% of my problems by naming all fields.
	[sql type="list" query=" ....."] [/sql base = 'data']

Notes. 
	I have never been able to get the [arg] ...[/arg] method
	of passing variables to work. I just use new syntax.

	I haven't been able to get [sql set] to actually interpolate 
	any variables. So I just use SQL LIST with a blank body.   



))  )) )  ))) )) )  )    )   ))  )    )   )      )))))  ) )  )) 
  P E T E R  B R O W N E L L      083 254 1491
   W E B   D E V .  M A N .	  Greenman@mailgate.net
   I  N  F  O  L  I  N  E         Johannesburg, South Africa  
				  http://www.infoline.web.za
-
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