LassoTalk
-
Re: MySQL complex query help
On Jan 28, 2012, at 11:59 AM, Jolle Carlestam wrote: > And, the explanation, Rick? That I missed the obvious... one of the fields I was performing my join on in the subcats table, subcat_id w...
8
in thread -
Re: MySQL complex query help
Try this: remove the GROUP BY and add DISTINCT. I think that will work. - - Marc On 28 jan. 2012, at 17:24, Bil Corry wrote: > Rick Dwyer wrote on 1/27/2012 11:39 PM: >> My goal is to fin...
8
in thread -
Re: Apache 2.2 RemoveHandler
Mason Miller wrote on 1/26/2012 8:47 PM: > <Location ~ "^.*\.[Hh][Tt][Mm][Ll]$"> > SetHandler lasso8-handler > </Location> > > I want this to work on everything, except files that reside in /...
2
in thread -
Re: MySQL complex query help
And, the explanation, Rick? HDB Jolle Sent from a thin, flat, touchy device from an undetermined place in space. 28 jan 2012 kl. 17:55 skrev "Rick Dwyer" <darksoftmoon@gmail.com>: > The p...
8
in thread -
Re: MySQL complex query help
The power of "Explain"... got it. Thanks Bil. On Jan 28, 2012, at 11:24 AM, Bil Corry wrote: > Rick Dwyer wrote on 1/27/2012 11:39 PM: >> My goal is to find all the main category names (one...
8
in thread -
Re: MySQL complex query help
Rick Dwyer wrote on 1/28/2012 8:41 AM: > Returns 0 even though I can see items with a manufacture year of 1967 and assigned to a subcategory which in turn is assigned to a category. > Will use expla...
8
in thread -
Re: User authentication table
Patrick Larkin wrote on 1/27/2012 7:14 AM: > Right now, I have two tables. One is a table of all staff in the organization. The other table contains staff usernames and passwords (encrypted) which...
5
in thread -
Re: MySQL complex query help
On Jan 28, 2012, at 11:24 AM, Bil Corry wrote: > Rick Dwyer wrote on 1/27/2012 11:39 PM: >> My goal is to find all the main category names (one occurence of >> each) for all items where the man...
8
in thread -
Re: MySQL complex query help
Rick Dwyer wrote on 1/27/2012 11:39 PM: > My goal is to find all the main category names (one occurence of each) for all items where the manufacture year is 1967 (items.manf_year). I think this is...
8
in thread -
Re: anyone know why this breaks in Lasso 9
Yes, that might be the key point (pun intended)! Have a faint recollection that we had issues with this when Knop was converted to 9. HDB Jolle Sent from a thin, flat, touchy device from an un...
10
in thread -
Re: anyone know why this breaks in Lasso 9
Could it be that you've quoted -keypair name whereas tami hasn't? Ke - sent from a phone On 28 Jan 2012, at 05:54, Jolle Carlestam <Jolle.Carlestam@amtac.net> wrote: > The knop_database type...
10
in thread -
MySQL complex query help
Hello all. Struggling trying to put together a SQL query... any help is appreciated. 3 tables followed by their key fields: category cat_id subcategory cat_id subcat_id items sub...
8
in thread -
Re: anyone know why this breaks in Lasso 9
It sounds like this thread applies to MySQL as well as FM and any other inline in 9. http://lasso.2283332.n4.nabble.com/Cant-update-records-LS9-FM11-tp4272006p4277414.html I rarely see code wher...
10
in thread -
Re: is output_none in Lasso9?
On 2012-01-28, at 1:08 AM, Jolle Carlestam wrote: > Regardless of suggested workarounds and coding practices. If the result from output_none differs depending on a carriage return or not then I agr...
12
in thread -
Re: is output_none in Lasso9?
28 jan 2012 kl. 07:03 skrev Jonathan Guthrie: > Could you then not just put it in a block like this? > > inline($writeCon) => { > // your code you want to not output anything goes here... > }...
12
in thread -
Re: RefCount
Mark Palmer wrote on 1/26/2012 1:26 PM: > Lasso 8.6 > > Local('a'=Null); > > #a->RefCount; > > Returns 2 > > Why would that be? That's how LP8 works. Fletcher mentioned on the list once (...
2
in thread -
Re: is output_none in Lasso9?
28 jan 2012 kl. 06:45 skrev Tami Williams: > Works in Lasso 8 - nothing shows, when access the pages via my other app I get the fusedoc stuff; but in Lasso 9 the 'bug' I found is the need to have a...
12
in thread -
Re: is output_none in Lasso9?
We gave Kyle a special t-shirt when he was here at the mothership recently for a visit. [ no_square_brackets ] :) On 2012-01-28, at 1:04 AM, Jolle Carlestam wrote: > Although I admit I'm n...
12
in thread -
Re: is output_none in Lasso9?
28 jan 2012 kl. 06:47 skrev Fletcher Sandbeck: > On Jan 27, 2012, at 9:32 PM, Jolle Carlestam wrote: > >> If I have a page consisting mostly of non Lasso content with the need to just display so...
12
in thread -
Re: is output_none in Lasso9?
Could you then not just put it in a block like this? inline($writeCon) => { // your code you want to not output anything goes here... } The capture block above, because it does not have the a...
12
in thread -
Re: anyone know why this breaks in Lasso 9
The knop_database type puts everything inside an array including -keyfield and sends it to a -delete inline. It works. #fields -> insert('-keyfield' = .'keyfield') #fields -> insert('-keyvalue' =...
10
in thread -
Re: is output_none in Lasso9?
On Jan 27, 2012, at 9:45 PM, Tami Williams wrote: > The block inside the output_none is so I can run all my code through another app to get the 'fusedoc' stuff - responsibilities, properties, varia...
12
in thread -
Re: anyone know why this breaks in Lasso 9
Tried it and that works. This means I can't just expect my Lasso 8 code to run, I'll have to re-write my update and delete inlines. So, // write Connection var('writeCon' = array( -username...
10
in thread -
Re: is output_none in Lasso9?
On Jan 27, 2012, at 9:32 PM, Jolle Carlestam wrote: > If I have a page consisting mostly of non Lasso content with the need to just display some tiny Lasso code I use the lassoscript shortcut: > P...
12
in thread -
Re: is output_none in Lasso9?
The block inside the output_none is so I can run all my code through another app to get the 'fusedoc' stuff - responsibilities, properties, variables. But, in the web app itself nothing should show in...
12
in thread -
Re: anyone know why this breaks in Lasso 9
OK, back home now... this is what we commonly use: var(gv_sql = array( -Database=$DBName, -Username=$ClientDBUsername, -Password=$ClientDBPassword, -maxRecords='all' ) )...
10
in thread -
Re: is output_none in Lasso9?
I don't understand your usage of output_none. You put it around a chunk of literal text that looks like its only purpose is that it should be shown. Personally I never ever use output_none. Then of c...
12
in thread -
RE: date->Format Lasso 9
That's why I should let you write the code! In all seriousness, the return on the investment from attending LDC in Toronto will be enormous, even more so for those of us who don't touch Lasso much...
5
in thread -
Re: is output_none in Lasso9?
Answer: output_none IS in Lasso 9 but I think I have a bug. Put this in a page and load it and you'll see the problem. [Output_None] <fusedoc fuse="lay_site.lasso" language="Lasso" specific...
12
in thread -
Re: date->Format Lasso 9
I had to work this out when my project manager, an Aussie dude, demanded the T and the Z in certain output. Could not find a ready made format for it, despite Lasso 9 supporting a humongous amount of...
5
in thread -
RE: date->Format Lasso 9
Ahhh, the double quotation marks strike again... well, it was a good waste of a few hours ;-) -Original Message- From: lasso-bounces@lists.lassosoft.com [mailto:lasso-bounces@lists.lassoso...
5
in thread -
Re: date->Format Lasso 9
28 jan 2012 kl. 03:42 skrev Rick Draper: > Hi All, > > I have been struggling today with getting a date format to work in Lasso 9... In 8.* I wrote it as ... > Date(Field('Expiry_GMT')) -> For...
5
in thread -
Re: anyone know why this breaks in Lasso 9
Have you tried the connection array without mentioning the keyfield, and pushing that to the inline instead? Unfortunately I'm not near my laptop but I know using connection arrays works because i...
10
in thread -
Re: anyone know why this breaks in Lasso 9
No, MySQL 5. On Jan 27, 2012, at 9:41 PM, Steve Piercy - Web Site Builder wrote: > Filemaker? > > See this thread: > http://lasso.2283332.n4.nabble.com/Cant-update-records-LS9-FM11-tp4272006...
10
in thread -
date->Format Lasso 9
SGkgQWxsLAoKSSBoYXZlIGJlZW4gc3RydWdnbGluZyB0b2RheSB3aXRoIGdldHRpbmcgYSBkYXRl IGZvcm1hdCB0byB3b3JrIGluIExhc3NvIDkuLi4gIEluIDguKiBJIHdyb3RlIGl0IGFzIC4uLgpE YXRlKEZpZWxkKCdFeHBpcnlfR01UJykpIC0+IEZvcm1h...
5
in thread -
Re: anyone know why this breaks in Lasso 9
Filemaker? See this thread: http://lasso.2283332.n4.nabble.com/Cant-update-records-LS9-FM11-tp4272006p4277414.html steve On 1/27/12 at 9:14 PM, lasso@asktami.com (Tami Williams) pronounc...
10
in thread -
anyone know why this breaks in Lasso 9
In Lasso 9.1.4 on Mac OS X 10.7 this inline doesn't work, I get a "delete" error, code (-9957): // write Connection var('writeCon' = array( -username = $dbusername, -password = $dbpassword...
10
in thread -
is output_none in Lasso9?
It doesn't seem that output_none works in Lasso 9. Is it supposed to? If not, is there a replacement? This message is sent to y...
12
in thread -
RE: User authentication table
Hi Patrick, We too use a separate table for Operator credentials from the general "human" data. If you are going to combine your tables it might be a good time to review password storage strategie...
5
in thread -
Re: User authentication table
Thanks. Yes, I have Lasso check to make sure both the username and password are completed before moving forward in the script. My old school code. I'm sure there is a better way to do this....
5
in thread -
Re: User authentication table
We keep our authentication table separate as well. It sounds like the goal is to get shorter login times. Are you sure that combining the tables will lead to shorter login times? (We don't notice any...
5
in thread -
User authentication table
Hello - I have a need to redo an authentication system I developed years ago to accommodate a change in our enterprise wide personnel system. Right now, I have two tables. One is a table of all...
5
in thread -
Apache 2.2 RemoveHandler
<Location ~ "^.*\.[Hh][Tt][Mm][Ll]$"> SetHandler lasso8-handler </Location> I want this to work on everything, except files that reside in /users in my web root/ Thanks, Mason #########...
2
in thread -
Tip: Finding out where you are and logging it if necessary
With the help of Kyle and Ke I've put together two methods that makes it convenient to find out where you are in your code and log it. First method: define whereami(-page::boolean = false, -line::...
1
in thread -
Re: Getting the present row number
26 jan 2012 kl. 15:14 skrev Kyle Jessup: > define whereami() => currentCapture->continuation->callSite_line Thanks! With this I've managed to get what I want. HDB Jolle #################...
15
in thread -
RefCount
Hi List, Lasso 8.6 Local('a'=Null); #a->RefCount; Returns 2 Why would that be? Regards Mark Palmer E: mark@pageworks.co.uk T: +44 1902 620500 W: www.pageworks.co.uk...
2
in thread -
Re: Ad-hoc Type Parameters
L8.x didn't support adhoc data members in that fashion =97 but if I recall correctly you could directly manipulate the types internal data map with type->properties->first etc... In Lasso 9 you c...
2
in thread -
Ad-hoc Type Parameters
I seem to remember that in Lasso 8.x we used to be able to create ad-hoc data-members for a type (from memory, and might be wrong): define('mytype'); /define; local('foo' = mytype); #foo-...
2
in thread -
Re: Getting the present row number
I'm not sure whether to find that encouraging or concerning! Had thought I rationalised it in my head... Ke On 26 January 2012 17:17, Kyle Jessup <kyle@lassosoft.com> wrote: > > I'm not e...
15
in thread -
Re: Fwd: Lasso 8.5 not serving pages?
CkhpIEFuZHJlYXMsCgpJdCBzb3VuZHMgbGlrZSB5b3UgbWlnaHQgaGF2ZSBzb21lIFNRTGl0ZSBj b3JydXB0aW9uLiBUcnkgdGhpczoKCjEpIFN0b3AgTGFzc28KMikgTmF2aWdhdGUgdG8gTGFzc28g UHJvZmVzc2lvbmFsIDgvTGFzc29TaXRlcy9kZWZhdWx0...
4
in thread
To find out more about this list or how to subscribe - choose the 'i' next to the list name on the right, or click here for more information about LassoTalk
Lasso Talk
RSS Feedcommunity
Related Technologies
