Thanks Everyone;
I got it working, and yes it wae the caps issue. But now I am really
confised as to the design of freetrade.
My query will only work with "query" and not "Query",
but in the "item_function" include unmodified and just downloaded today in
the newest CVS the query is "Query"??????
Yet in the "ListInvoiceContents" include also brand new the query is
"query"?
Why does it work with caps sometimes and small other times?
What am I missing here?
Shawn
----- Original Message -----
From: "Tommy TradeIT" <[EMAIL PROTECTED]>
To: "FreeTrade" <[EMAIL PROTECTED]>
Sent: Tuesday, September 12, 2000 8:15 PM
Subject: Re: [FreeTrade] Need help with query
> Hi shawn.
> � think the problem is in your var. You got smallcaps and big caps (query
> and Query)
>
> Tommy
> ----- Original Message -----
> From: "Shawn" <[EMAIL PROTECTED]>
> To: "FreeTrade" <[EMAIL PROTECTED]>
> Sent: Tuesday, September 12, 2000 9:24 AM
> Subject: [FreeTrade] Need help with query
>
>
> > Hello All;
> >
> > I am hoping that someone can help me out. I am trying to use the
folloing
> > query in my store and it does not work. As far as I can tell it is
> correct
> > and wneh I use it on MySQLAdmin it works fine as well as working fine
with
> > another MySQL frontend program. All the data display but it is as if
the
> > WHERE ProvinceState line is being ignored since nothing is filtered out.
> > What am I doing wrong?
> > Shawn
> >
> >
> > $query = "SELECT ID, Name, Address, Phone, WebSite, Email, Country,
> > ProvinceState ";
> > $query .= "FROM retailer ";
> > $Query .= "WHERE ProvinceState = 'Alabama' ";
> > $query .= "ORDER BY Name";
> >
> >
> >
> > ------------------------------------------------------------
> > To subscribe: [EMAIL PROTECTED]
> > To unsubscribe: [EMAIL PROTECTED]
> > Site: http://www.working-dogs.com/freetrade/
> > Problems?: [EMAIL PROTECTED]
> >
>
>
>
> ------------------------------------------------------------
> To subscribe: [EMAIL PROTECTED]
> To unsubscribe: [EMAIL PROTECTED]
> Site: http://www.working-dogs.com/freetrade/
> Problems?: [EMAIL PROTECTED]
------------------------------------------------------------
To subscribe: [EMAIL PROTECTED]
To unsubscribe: [EMAIL PROTECTED]
Site: http://www.working-dogs.com/freetrade/
Problems?: [EMAIL PROTECTED]
