[cfaussie] Re: best compromise? CF6.1 QueryOfQuery datatype mismatch.

2006-10-23 Thread Barry Beattie
thanx Gareth - BUT - the trouble is that I've actually got 2 manufactured queries to add to the real one, potentially with many rows each and I'm cautious in adding just a bit too much processing to something that's just hanging in there, performance wise... correct me if I'm wrong, the only wa

[cfaussie] Re: best compromise? CF6.1 QueryOfQuery datatype mismatch.

2006-10-23 Thread Gareth Edwards
Why not append the manufactured query to the existing query, and then sort it using QofQ? Cheers Gareth. Barry Beattie wrote: > hi all. > > I've got a CF6.1 problem (solved in CF7) where I'm running a > QueryOfQuery union between two queries, one of which is manufactured > and may have empty st

[cfaussie] best compromise? CF6.1 QueryOfQuery datatype mismatch.

2006-10-23 Thread Barry Beattie
hi all. I've got a CF6.1 problem (solved in CF7) where I'm running a QueryOfQuery union between two queries, one of which is manufactured and may have empty strings. the resulting query is to feed a datagrid for editing. I *have* to use the QofQ to mash all the data together correctly (ie: "orde

[cfaussie] Re: Getting a NT user's name

2006-10-23 Thread Tom MacKean
Thanks On 10/24/06, grant <[EMAIL PROTECTED]> wrote: if they're already logged in the username and domain should be in the cgi scope - remote_user or auth_user. you may need to turn anonymous access off in the server settings so that the value is passed through to the server... hth  On 10/24/

[cfaussie] Re: Getting a NT user's name

2006-10-23 Thread Scott Arbeitman
Look at CGI.Remote_User and also try GetAuthUser() --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "cfaussie" group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, sen

[cfaussie] Re: Getting a NT user's name

2006-10-23 Thread grant
if they're already logged in the username and domain should be in the cgi scope - remote_user or auth_user. you may need to turn anonymous access off in the server settings so that the value is passed through to the server... hth  On 10/24/06, Tom MacKean <[EMAIL PROTECTED]> wrote: Using cfNTauth

[cfaussie] Getting a NT user's name

2006-10-23 Thread Tom MacKean
Using cfNTauthenticate I can get a user to log in and check that they are part of the domain. But if they are already logged onto the network and are browsing the page from a logged on machine, is it possible to collect the user name without making them log in? i.e. Can CF find out which NT user i

[cfaussie] Re: JavaScript - testing for an exponential number

2006-10-23 Thread Chris Velevitch
Does it make sense to have someone enter 1 byte? What 100, 1 or 1Mb or 12345678 bytes? Since it's for specifying how much space someone wants a database to be, I suggest you pick a unit of measure, say 100 Mb for example, and then allow people to enter a number which will be a number of 100's

[cfaussie] JavaScript - testing for an exponential number

2006-10-23 Thread neilza
Hi I wondered if someone could help. I have a field in a form whereby the user enters the amount of space in bytes they would like their database to be. The entry made by the user will be in one of two formats, either the number of bytes required in full e.g. 1 (100MB) or alternatively