Beefy Boxes and Bandwidth Generously Provided by pair Networks
XP is just a number
 
PerlMonks  

Re^2: Dont allow multiple registrations or automated script problem

by Nik
on Oct 21, 2006 at 15:08 UTC ( #579765=note: print w/ replies, xml ) Need Help??


in reply to Re: Dont allow multiple registrations or automated script problem
in thread Dont allow multiple registrations or automated script problem

And what would do the same in MySQL ?
Why the name filed is bad? Whats hould i be using?


Comment on Re^2: Dont allow multiple registrations or automated script problem
Re^3: Dont allow multiple registrations or automated script problem
by ptum (Priest) on Oct 23, 2006 at 14:20 UTC

    With respect to your MySQL date function syntax question, you might want to look it up. Personally, I would be a little embarrassed to ask such a question; I would be afraid people would think I was lazy or expected everything to be handed to me on a platter.

    With respect to naming conventions, I think it is a bad idea to identify table columns with reserved words (even if the reserved token isn't reserved in the database or language I'm using). In this case, "DATE" is a reserved type in Oracle, which is a pretty commonly-used database. If you ever ported your code to using Oracle on the back end, you'd have to change that column name (admittedly, this may not be a worry for you). In any case, it is not a very informative name for a table column -- IMO that's like calling your IP address field "STRING".

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://579765]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others surveying the Monastery: (6)
As of 2014-12-25 20:37 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    Is guessing a good strategy for surviving in the IT business?





    Results (163 votes), past polls