SitePoint Sponsor

User Tag List

Results 1 to 4 of 4

Thread: SQL Field Type

  1. #1
    SitePoint Addict
    Join Date
    Sep 2003
    Location
    CA
    Posts
    264
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    SQL Field Type

    I have a script which requires me to:
    To enable authentication, each table you want to protect must have a field whose field type is set to ID_user;
    Kinda a noob question I'm sure, but what do they mean by 'field type'? Is this the field name? Or something else?

    I just can't get it to work correctly with the SQL table that I've already built, and I have a feeling this is why.

  2. #2
    SQL Consultant gold trophysilver trophybronze trophy
    r937's Avatar
    Join Date
    Jul 2002
    Location
    Toronto, Canada
    Posts
    39,347
    Mentioned
    63 Post(s)
    Tagged
    3 Thread(s)
    from the sentence you quoted, field type appears to mean datatype

    however, ID_user is a datatype with which i am not familiar

    is this a user-defined datatype in SQL 2005 or something?
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL
    "giving out my real stuffs"

  3. #3
    SitePoint Addict
    Join Date
    Sep 2003
    Location
    CA
    Posts
    264
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Quote Originally Posted by r937 View Post
    from the sentence you quoted, field type appears to mean datatype

    however, ID_user is a datatype with which i am not familiar

    is this a user-defined datatype in SQL 2005 or something?
    Yea, I looked up datatypes too via Google to make sure it wasn't something I missed. The script runs on my SQL 4.1.22-standard installation, so I assume it's referring to something that should work with that (the scripts docs also say this is supported).

    I inserted a 'ID_user' field into my database, but the script doesn't seem to interact with that.

    Oh, the script I'm using is:
    http://www.dadabik.org/index.php

    if that helps at all. I'm trying to get the user authentication system to work without having much luck..

  4. #4
    SitePoint Addict
    Join Date
    Sep 2003
    Location
    CA
    Posts
    264
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    HAH!

    Well, for who ever is googling this thread and comes across it, it's actually a datatype that the SCRIPT uses, which is setup by changing the field id_user to be the type id_user via the script.

    I spent two days trying to figure that out. Ugh.

    In any event, thanks for your help.


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •