www.webdeveloper.com

Search:

Type: Posts; User: b4web

Search: Search took 0.01 seconds.

  1. Replies
    2
    Views
    947

    Are you missing a closing paren for the role?

    Are you missing a closing paren for the role?
  2. Replies
    2
    Views
    1,688

    For the creation of your view, couldn't you use...

    For the creation of your view, couldn't you use this select?

    select max(id), owner, document from doctable group by owner, document;

    Then I think you would have the id of the most current...
  3. Replies
    5
    Views
    1,551

    I don't know the DBMS syntax, but I think this...

    I don't know the DBMS syntax, but I think this
    "foreign key(id33) references table1,foreign key(id33) references table2)"
    should be more like this
    Foreign Key (id1x) references table1(id1)...
  4. Replies
    1
    Views
    755

    Looking at the mysql 5.0 reference manual, under...

    Looking at the mysql 5.0 reference manual, under other functions, there is a function called row_count() - returns the number of rows updated, inserted, or deleted by the preceding statement and it...
  5. Replies
    5
    Views
    963

    Is there a "IN" in MSSQL? For example: Select...

    Is there a "IN" in MSSQL? For example:

    Select ..... Where attribute_values IN #form.searchsize#
  6. Replies
    2
    Views
    2,130

    Are you pointing to different copies of the...

    Are you pointing to different copies of the database (i.e. development version of the database vs. live production version of the database)?
  7. Thread: I suck at Oracle

    by b4web
    Replies
    2
    Views
    1,502

    I think that you need a GROUP BY and that it will...

    I think that you need a GROUP BY and that it will need to include all the columns you selected.
  8. Thread: MySQL Skills

    by b4web
    Replies
    8
    Views
    1,534

    Joseph - If someone like a DataBase Administrator...

    Joseph - If someone like a DataBase Administrator is taking care of the database, then you probably don't need to worry about the backup, recovery and some of the database functions. You should...
  9. Replies
    5
    Views
    1,273

    Hi. I know you have this resolved, but based on...

    Hi. I know you have this resolved, but based on what you said, I think that you want an automatic update whenever the row gets updated. You may want to do some research into your MySQL's procedures...
  10. I think that you need to use the "Group By"...

    I think that you need to use the "Group By" clause and alias names. I don't know if the following sql is right or not because I don't have time to setup tables to test this, but I'm thinking along...
  11. Replies
    5
    Views
    1,551

    Seems okay to me

    Table 1 primary key of 'iop' has been inserted.

    Table 2 primary key of 'rey' has been inserted.

    Table 3 primary key of 'you did not specify with 'ioprey' as the foreign key should work. Is...
  12. Do you have indexes defined? Below is from MySQL...

    Do you have indexes defined? Below is from MySQL 5.0 Reference:


    "14.2.6.4. FOREIGN KEY Constraints
    InnoDB also supports foreign key constraints. The syntax for a foreign key constraint...
  13. Replies
    2
    Views
    2,394

    Insert or update triggers may be helpful. For...

    Insert or update triggers may be helpful. For instance, if deptname is the column that you want in uppercase then for an insert:

    create trigger dept_name_caps before insert on depttable for each...
  14. Agree, union will work. select a.dept_id,...

    Agree, union will work.

    select a.dept_id, a.acct, a.spend, a.budget from budget a, dept where dept.dept_id=a.dept_id and dept.acct=a.acct
    union select dept_id, acct, 0, 0 from dept where not...
Results 1 to 14 of 14
HTML5 Development Center



Recent Articles