search of the:   for: 
code logs -> 2008 -> Fri, 07 Mar 2008< code.20080306.log - code.20080308.log >
--- Log opened Fri Mar 07 00:00:44 2008
00:03 You're now known as TheWatcher[zZzZ]
00:52 GeekSoldier|pub is now known as GeekSoldier
--- Log closed Fri Mar 07 01:18:02 2008
--- Log opened Fri Mar 07 01:18:38 2008
01:18 TheWatcher[zZzZ] [~chris@Nightstar-29731.dsl.in-addr.zen.co.uk] has joined #code
01:18 Irssi: #code: Total of 17 nicks [8 ops, 0 halfops, 0 voices, 9 normal]
01:18 mode/#code [+o TheWatcher[zZzZ]] by ChanServ
01:19 Irssi: Join to #code was synced in 43 secs
01:35 GeekSoldier is now known as GeekSoldier|bed
02:46 gnolam [lenin@Nightstar-10613.8.5.253.static.se.wasadata.net] has quit [Quit: Z?]
03:37 Pi-2 is now known as Pi
03:37 Pi is now known as NSGuest-5434
03:37 NSGuest-5434 is now known as Pi-1
03:43 Pi-1 is now known as Pi
05:23 AnnoDomini [AnnoDomini@83.21.30.ns-3753] has joined #Code
05:23 mode/#code [+o AnnoDomini] by ChanServ
05:39
< Vornicus>
Holy crap, on-topic spam in the postscript newsgroup.
05:40
< Vornicus>
Plotter supplies!
05:46 * AnnoDomini laughs.
06:05 C_tiger [~c_wyz@96.232.26.ns-11798] has quit [Ping Timeout]
06:21 C_tiger [~c_wyz@Nightstar-16221.nycmny.east.verizon.net] has joined #code
07:44 Kazriko [~kaz@Nightstar-26352.gdj-co.client.bresnan.net] has joined #code
07:45 GeekSoldier|bed is now known as GeekSoldier
07:45 Kazriko is now known as NSGuest-5440
07:45 NSGuest-5440 is now known as Kaz
07:46 Kaz is now known as Kazriko
08:10 Vornicus is now known as Vornicus-Latens
08:17 Kazriko [~kaz@Nightstar-26352.gdj-co.client.bresnan.net] has quit [Quit: Leaving]
08:19 Kazriko [~kaz@Nightstar-26352.gdj-co.client.bresnan.net] has joined #code
08:38 You're now known as TheWatcher
10:49 NightRain [~NightRain@Nightstar-3946.worldnet.co.nz] has quit [Quit: Leaving]
11:00 gnolam [lenin@Nightstar-10613.8.5.253.static.se.wasadata.net] has joined #Code
11:00 mode/#code [+o gnolam] by ChanServ
11:30 AnnoDomini [AnnoDomini@83.21.30.ns-3753] has quit [Ping Timeout]
11:37 AnnoDomini [AnnoDomini@83.21.84.ns-3004] has joined #Code
11:37 mode/#code [+o AnnoDomini] by ChanServ
12:28
<@Reiver>
Vornicus: Was your comment regarding Diminishing Marginal Returns related to my query, or?
12:28 GeekSoldier [~Rob@91.18.96.ns-4729] has quit [Ping Timeout]
13:11 GeekSoldier [~Rob@91.18.81.ns-3759] has joined #code
15:04 Netsplit Blargh.CA.US.Nightstar.Net <-> Troika.TX.US.Nightstar.Net quits: Serah, Attilla, @MyCatVerbs, @AnnoDomini, @Reiver, C_tiger, @ToxicFrog, GeekSoldier, Pi, Vornicus-Latens, (+5 more, use /NETSPLIT to show all of them)
--- Log closed Fri Mar 07 15:30:49 2008
--- Log opened Fri Mar 07 15:30:55 2008
15:30 TheWatcher [~chris@Nightstar-29731.dsl.in-addr.zen.co.uk] has joined #code
15:30 Irssi: #code: Total of 16 nicks [8 ops, 0 halfops, 0 voices, 8 normal]
15:30 mode/#code [+o TheWatcher] by ChanServ
15:31 Irssi: Join to #code was synced in 47 secs
15:52 gnolam [lenin@Nightstar-10613.8.5.253.static.se.wasadata.net] has quit [Ping Timeout]
16:35 EvilDarkLord [~jjlehto3@Nightstar-2194.vipunen.hut.fi] has joined #Code
16:35 Kazriko [~kaz@Nightstar-26352.gdj-co.client.bresnan.net] has joined #Code
16:35 gnolam [lenin@Nightstar-10613.8.5.253.static.se.wasadata.net] has joined #Code
16:36 gnolam is now known as NSGuest-5444
17:09 You're now known as TheWatcher[afk]
17:16 Vornicus-Latens is now known as Vornicus
17:18
< Vornicus>
Reiver: it was, actually, yes.
18:35 You're now known as TheWatcher
19:08 NSGuest-5444 is now known as gnolam
20:50
<@AnnoDomini>
Entspeak, heh.
22:44
<@McMartin>
hoom
22:48
< GeekSoldier>
I'd like to make an entish response myself, but it's still too soon since McM's reply.
23:07 Mango [~Mango@24.86.100.ns-4243] has joined #code
23:09 * Mango is here for a monologue.
23:09
< Mango>
My usual channel is empty.
23:10
< Mango>
And monologues to an empty channel just feels silly.
23:12
< Mango>
Right. So.
23:12 GeekSoldier is now known as GeekSoldier|bed
23:12
< Mango>
I'm using Ajax to pass data between a javascript customer management program and a MySQL database
23:12
< Mango>
('night, GeekSoldier)
23:13
< GeekSoldier|bed>
(sorry to interrupt your monologue, goodnight!)
23:13
< Mango>
You can have multiple customers open at one time, and the containers are identified by some unique ID.
23:13
< Mango>
(No problem.)
23:14
< Mango>
Now, it would make code a lot simpler if the ID used in the Javascript was the same as the ID from MySQL, and the customer's account number.
23:14
< Mango>
But! What happens when we create a new account?
23:14
< Vornicus>
You create a new ID, somewhere.
23:14
< Mango>
1) We use a unique ID that has nothing to do with the DB and make the code royally confusing.
23:15
< Mango>
2) We create a new ID in the database
23:15
< Vornicus>
So, make the account number the primary key in the accounts table...
23:15
< Mango>
(it is.)
23:15
< Vornicus>
Okay.
23:16 * Mango waits to see what Vorn was going to say
23:16
< Vornicus>
I don't see why you would need anything beyond that, though.
23:16
< Mango>
well,
23:16
< Mango>
the procedure could go like this...
23:16
< Vornicus>
I mean, there's middleware, right?
23:16
< Mango>
middleware?
23:16
< Vornicus>
Something mediating between the ajax calls and the database, so you don't generate queries client side?
23:17
< Mango>
ah, yep, PHP.
23:17
<@McMartin>
That's not necessarily sufficient.
23:17
<@McMartin>
If you're generating queries client side, you quite frankly have much larger problems than DB primary keys~
23:17
< Mango>
right.
23:17
< Mango>
so...
23:17
< Vornicus>
So, you can do all the account number creation in the php, can't you?
23:17
<@McMartin>
(This would be if AJAX is actually sending in the "SELECT * from. .."...)
23:17
< Mango>
McMartin, don't worry, it's not :)
23:17
<@jerith>
I switched to this window and saw "PHP".
23:18
<@jerith>
Is my Napalm of Enlightenment required?
23:18
<@McMartin>
(OK, just checking, because you never know~)
23:18 * Mango chuckles
23:18
< Mango>
yep, but then if the user decided "Oh, I don't want to create a new account after all," I'd be left with an empty account floating about somewhere
23:18
< Mango>
so
23:18
< Vornicus>
Mango: then, you wait until you've got all the information you need to generate an account number.
23:19
< Mango>
I think what I need is a cron job that runs daily and simply removes any accounts that do not have a first name and last name
23:19
< Vornicus>
Why are you creating the account in the thing without this information in the first place?
23:19
< Mango>
because...
23:19
< Mango>
I need a form for the user to fill out to ask for that information
23:19
< Mango>
and the form needs a unique ID
23:20
< Vornicus>
...why does the /form/ need a unique id?
23:20
< Mango>
the program can open an unlimited number of accounts at one time. (theoretically.)
23:20
< Vornicus>
Okay, so rate limit your account creation.
23:20
< Mango>
rate limit?
23:21
< Vornicus>
Ignore multiple rapid-fire requests.
23:21
< Vornicus>
Creating a unique id for the form doesn't prevent floods.
23:22
< Mango>
no, of course not
23:22
< Mango>
but it makes it easy to figure out which accounts you have open
23:22
< Vornicus>
I must admit, I am not seeing the problem. Person fills out the form, submits it, PHP examines, determines if all the required fields are there, and creates the account
23:22
< Mango>
cool :)
23:23
< Vornicus>
And /then/ has the account number.
23:23
< Vornicus>
creates it, rather
23:23
< Mango>
Oo!
23:23
< Mango>
Hrm.
23:23
< Vornicus>
I don't see how making a "create account" thing get an ID number before everything is initialized helps you in any way.
23:23
< Mango>
document.getElementById("someId").id = "someOtherId";
23:23
< Mango>
anyone know offhand if that would work?
23:24
< Vornicus>
I don't see why it wouldn't, but why on earth...
23:25
< Mango>
well, the form has to have a unique ID
23:26
< Mango>
so that when the Javascript program needs to access data from it, it knows which of the dozens of forms to use.
23:26
< Mango>
I just figured it'd make code simpler if formID = accountID
23:27
< Vornicus>
I'm still lost, I think
23:27
< Vornicus>
Why are there dozens of forms?
23:27
< Mango>
because one might be dealing with multiple customers at once.
23:28
< Vornicus>
Huh?
23:28
< Vornicus>
I still don't see why this requires a unique id for the /form/.
23:29
< Mango>
well
23:30
< Mango>
say three customers walk in, Tom, Dick, and Harry
23:30
< Vornicus>
Okay. Open one window for each customer.
23:30
< Mango>
ahhhhh, I see where the confusion is
23:30
< Mango>
it's ajax-based
23:30
< Mango>
so they're all in the same browser window
23:30
< Vornicus>
Tom fills out his stuff, Dick fills out his, Harry fills out his, and then you go and...
23:30
< Vornicus>
Why the hell would you do that?
23:31
< Mango>
speed and efficiency, mainly
23:31
< Vornicus>
I'm... not seeing it.
23:31
< Mango>
keep in mind this is software staff use, it's not for end users
23:31
< Vornicus>
Okay, and?
23:32
< Mango>
so, say you're looking up a customer.
23:32
< Vornicus>
Okay, looking up a customer.
23:32
< Mango>
without ajax, you have to download all the HTML, and pretty pictures, and the form, and maybe a menu, and whatnot
23:32
< Mango>
with ajax, here's what you download:
23:33
< Mango>
customerLoad(["firstname","lastname","address","phone"]);
23:33
< Mango>
the program generates the form itself and fills it with the values
23:33
< Mango>
it basically acts like a desktop application
23:33
< Vornicus>
I still don't see why ajax makes just plain old submission-response setup impossible.
23:34
< Mango>
well
23:34
< Mango>
you have five customers open
23:34
< Mango>
five forms on one page
23:35
< Vornicus>
So?
23:35
< Vornicus>
Also, scrolling is inferior to tabs.
23:35
< Mango>
each form having a unique ID is one way of telling which form is which
23:35
< Mango>
(it uses tabs.)
23:35
< Vornicus>
Okay, so far you've said nothing that makes a /new account/ form require an ID.
23:36
< Vornicus>
Existing accounts you have the account number and you're throwing that around, obviously, in hidden fields or something
23:36
< Mango>
well,
23:36
< Vornicus>
But with new accounts, you submit a "create account" message and it /gets back to you/ with an account ID.
23:36
< Mango>
ok.
23:37
< Mango>
but when it gets back to me, how does the javascript know what form to apply that ID to?
23:37 * Vornicus eyes
23:38
< Vornicus>
Okay, here's what you do - it says "have an account!" and gives you all the information needed to create a display page, and when you submit, it destroys the create-account page.
23:39
<@MyCatVerbs>
Another addition to the official List of Things That Kinda Suck.
23:39
<@MyCatVerbs>
Specifically: "null" in what is supposed to be a numerical field in a text file.
23:40
< Mango>
Vorn, possible.
23:40 * Mango considers that.
23:40
<@MyCatVerbs>
I'd smack the guy who did that, but I kinda need his cooperation since he's one of not many people I can actually get work out of. ^_^
23:40
< Mango>
MyCatVerbs: I hear ya :-/
23:40 You're now known as TheWatcher[T-2]
23:41
<@MyCatVerbs>
Mango: I have a kludge for it, and some naughty words in the version control. ^_^
23:41
< Mango>
hehe
23:47 You're now known as TheWatcher[zZzZ]
23:48
< Mango>
MCV: We have First Name, Last Name, and Business Name
23:49
< Mango>
I routinely get complaints that reports aren't alphabetizing properly
23:49
< Mango>
and do you know why?
23:49
< Mango>
because they put things like this:
23:49
< Mango>
First Name: Joe's
23:49
< Mango>
Last Name: Autobody
23:49
< Mango>
Business Name: Joe McCarthy
23:50
< Mango>
>.<
23:50
< Serah>
>_<
23:50
<@AnnoDomini>
;_;
23:50
< Vornicus>
heh
23:51
< Mango>
just...WHY!? OF COURSE it's going to alphabetize wrong if you put stuff in the wrong place.
23:51
< C_tiger>
Mango that means the form is probably not as intuitive as it should be.
23:51
< Mango>
possibly.
23:52
< Mango>
I think I'll change "Other name" to "Other/Business name"
23:52
< Mango>
that might help.
--- Log closed Sat Mar 08 00:00:54 2008
code logs -> 2008 -> Fri, 07 Mar 2008< code.20080306.log - code.20080308.log >
 search of the:   for: