Setting up Multiple Company Accounts Hosted by on Database in MySQL using Alpha Anywhere

[aburningflame]

Re: Setting up Multiple Company Accounts Hosted by on Database in MySQL using Alpha Anywhere

isn't that the other part of the single quote right after the userid.
i expanded to show the single quote from the post, in order to use the pUser.userid with single quotes around it.
isn't it?

edit: i noticed while i am writing, peter has pointed out the same idea.

The ' single quotes are to quote strings. In MYSQL you compare strings like so: stringField='scott'

So userid='24' is just comparing it as a string. This still works, because - as far as i know - mysql would implicitly convert userid to string to compare.
So technically, if userid is a numeric field, you do not need the quotes.
userid=24.

I prefer to use arguments, both for readability, ease of writing, and protection against sql injection
Hope this example helps

dim args as SQL::Arguments
args.set("cid",session.companyID)

dim no_of_employees as N=sql_lookup("::name::conn","users","companyid=:cid AND active=1","COUNT(*)",[B]args[/B])

[CharlesParker]

Re: Setting up Multiple Company Accounts Hosted by on Database in MySQL using Alpha Anywhere

Thanks Scott but my knowledge limits me. I do get that it signifys a string, my question has been answered.
Even though it has, now I am looking at your code example: It looks like it says the following
dim an arg a SQL arg
call one of the arg's "set" and give it a value of (cid and the session varible)

Then is says to call no of employees a number with a value of the following sql lookup
"connection path" from teh users table the company id = cid and if active = the value of 1 loop through assigning the value for each user

am I right or am I waaaaay off?
I sure hope I am at least close as I am putting it out there as to how dumb I am if I wrong lol...
and so much for being self taught. I did the same thing with the guitar, turns out I am not a good guitar teacher either

[GGandhi]

Re: Setting up Multiple Company Accounts Hosted by on Database in MySQL using Alpha Anywhere

The ' single quotes are to quote strings. In MYSQL you compare strings like so: stringField='scott'

in mysql you can use either single quote or double quotes for a string, but when you want to quote inside a quote then you need to use the other unused quote.
so, if you want to enclose a quote inside double quote then you use the single quote and vice versa.
"stringField='scott' "
'stringField="scott" '
are acceptable as far as i know.
this is what i understood about quotes. and this is what was in that statement where the question addressed.
i just clarified.

and yes, arguments are better and safe.

[aburningflame]

Re: Setting up Multiple Company Accounts Hosted by on Database in MySQL using Alpha Anywhere

Thanks Scott but my knowledge limits me. I do get that it signifys a string, my question has been answered.
Even though it has, now I am looking at your code example: It looks like it says the following
dim an arg a SQL arg
call one of the arg's "set" and give it a value of (cid and the session varible)

Then is says to call no of employees a number with a value of the following sql lookup
"connection path" from teh users table the company id = cid and if active = the value of 1 loop through assigning the value for each user

am I right or am I waaaaay off?
I sure hope I am at least close as I am putting it out there as to how dumb I am if I wrong lol...
and so much for being self taught. I did the same thing with the guitar, turns out I am not a good guitar teacher either

I hear ya on the self taught guitar - been playing a while myself :) - not that easy!
Read the comments below - see if that helps

[B]dim showActiveOnly as L=.f.[/B] (or .t. - or this value can be set based on user input, etc)

[B]dim args as SQL::Arguments[/B] 'dim a new variable named args, with the type of SQL::Arguments . SQL::Arguments is an object used to hold a [B]collection[/B] of arguments
[B]args.set("cid",session.companyID)[/B] 'create a argument [B]named[/B] [B]cid[/B] and give it a [B]value[/B] of whatever is in session.companyID - the set method will create the variable if it does not exist, or modify an existing variable
[B]args.set("active",showActiveOnly)[/B] 'create another argument [B]named[/B] [B]active[/B] and give it a [B]value[/B] of whatever is in the showActiveOnly variable


'statements are read from RIGHT to LEFT
'call the sql_lookup [B]function[/B] 
'Param1: Our named connection, 
'Param2: Our table, 
'Param3: our filter (:name denotes a named argument), 
'Param4: Retrieve the COUNT of all records (see mysql COUNT function), 
'Param5: Pass in our arguments object so sql lookup knows where to get the value of :cid and :active
'evaluate the sql lookup and store its RETURNED VALUE into a numeric variable named number of employees
[B]dim no_of_employees as N=sql_lookup("::name::conn","users","companyid=:cid AND active=:active","COUNT(*)",args)[/B]

'If showActiveOnly is true:This example loads the number of employees that are active at the company and will return that number e.g 55
'If showActiveOnly is false:This example loads the number of employees that are active at the company and will return that number e.g 10

[CharlesParker]

Re: Setting up Multiple Company Accounts Hosted by on Database in MySQL using Alpha Anywhere

Thanks for taking the time to explain that. I know its probably cumbersome to take the time to write out what should be pretty basic stuff after awhile.
I have actually been reading all I can (time permitting) and working at least 4-6 hours a day with alpha5 on good days with a minimum of 2 hours no matter what in the evenings.

So far I actually have a functioning multi tenant app - and I did it all through good advice on here and perseverance, oh and coffee and beer, and some hard liqueur.

Now I am hunting around for all the help I can get - so thanks for taking YOUR time!
Lots of fun!

[aburningflame]

Re: Setting up Multiple Company Accounts Hosted by on Database in MySQL using Alpha Anywhere

Thanks for taking the time to explain that. I know its probably cumbersome to take the time to write out what should be pretty basic stuff after awhile.
I have actually been reading all I can (time permitting) and working at least 4-6 hours a day with alpha5 on good days with a minimum of 2 hours no matter what in the evenings.

So far I actually have a functioning multi tenant app - and I did it all through good advice on here and perseverance, oh and coffee and beer, and some hard liqueur.

Now I am hunting around for all the help I can get - so thanks for taking YOUR time!
Lots of fun!

Heh :) no problem. I have gotten assistance here too, so I like to answer questions once in a while - sort of my way of giving back.
We also offer 1to1 mentoring / consulting for example if you wanted to know how to go about doing a certain task etc.

Feel free to throw me an email (and one of those beers) if you ever feel the need to!

Thanks,
Scott