Click here to Skip to main content
15,867,834 members
Home / Discussions / Database
   

Database

 
QuestionHow to get generated Primary Key when adding a record Pin
gunner_uk200018-Dec-07 1:35
gunner_uk200018-Dec-07 1:35 
AnswerRe: How to get generated Primary Key when adding a record Pin
Pete O'Hanlon18-Dec-07 1:38
subeditorPete O'Hanlon18-Dec-07 1:38 
AnswerRe: How to get generated Primary Key when adding a record Pin
Giorgi Dalakishvili18-Dec-07 1:42
mentorGiorgi Dalakishvili18-Dec-07 1:42 
Questionselect the max value from the row and its other values Pin
Deques18-Dec-07 1:19
Deques18-Dec-07 1:19 
GeneralRe: select the max value from the row and its other values Pin
Tobias Schoenig18-Dec-07 1:41
Tobias Schoenig18-Dec-07 1:41 
GeneralRe: select the max value from the row and its other values Pin
Deques18-Dec-07 1:51
Deques18-Dec-07 1:51 
GeneralRe: select the max value from the row and its other values Pin
Tobias Schoenig18-Dec-07 1:59
Tobias Schoenig18-Dec-07 1:59 
GeneralRe: select the max value from the row and its other values Pin
Deques18-Dec-07 2:05
Deques18-Dec-07 2:05 
It still doesnt work.
It says an aggregate cant be in WHERE clause

An aggregate may not appear in the WHERE clause unless it is in a subquery contained in a HAVING clause or a select list, and the column being aggregated is an outer reference.

Tried with Having and it gives a lot other errors
GeneralRe: select the max value from the row and its other values Pin
Tobias Schoenig18-Dec-07 2:10
Tobias Schoenig18-Dec-07 2:10 
GeneralRe: select the max value from the row and its other values Pin
Deques18-Dec-07 2:17
Deques18-Dec-07 2:17 
GeneralRe: select the max value from the row and its other values Pin
Tobias Schoenig18-Dec-07 2:22
Tobias Schoenig18-Dec-07 2:22 
GeneralRe: select the max value from the row and its other values Pin
Deques18-Dec-07 2:31
Deques18-Dec-07 2:31 
GeneralRe: select the max value from the row and its other values Pin
Tobias Schoenig18-Dec-07 2:32
Tobias Schoenig18-Dec-07 2:32 
GeneralRe: select the max value from the row and its other values Pin
Deques18-Dec-07 2:43
Deques18-Dec-07 2:43 
GeneralRe: select the max value from the row and its other values Pin
Tobias Schoenig18-Dec-07 2:49
Tobias Schoenig18-Dec-07 2:49 
GeneralRe: select the max value from the row and its other values Pin
Deques18-Dec-07 2:53
Deques18-Dec-07 2:53 
GeneralRe: select the max value from the row and its other values Pin
Rupert Todd19-Dec-07 9:36
Rupert Todd19-Dec-07 9:36 
Generalcalling a storedprocedure from a function in mysql Pin
sepel18-Dec-07 0:35
sepel18-Dec-07 0:35 
GeneralDatabase Timeout!!!! Pin
__yash__18-Dec-07 0:19
professional__yash__18-Dec-07 0:19 
GeneralRe: Database Timeout!!!! Pin
Pete O'Hanlon18-Dec-07 0:26
subeditorPete O'Hanlon18-Dec-07 0:26 
GeneralRe: Database Timeout!!!! Pin
__yash__18-Dec-07 0:41
professional__yash__18-Dec-07 0:41 
GeneralRe: Database Timeout!!!! Pin
Pete O'Hanlon18-Dec-07 1:13
subeditorPete O'Hanlon18-Dec-07 1:13 
GeneralRe: Database Timeout!!!! Pin
__yash__18-Dec-07 1:29
professional__yash__18-Dec-07 1:29 
QuestionRe: Database Timeout!!!! Pin
David Crow19-Dec-07 2:29
David Crow19-Dec-07 2:29 
GeneralRe: Database Timeout!!!! Pin
__yash__20-Dec-07 0:39
professional__yash__20-Dec-07 0:39 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.