Click here to Skip to main content
15,566,114 members
Home / Discussions / Database
   

Database

 
AnswerRe: how to select numbers (integers) only? Pin
Richard MacCutchan16-Jul-14 23:54
mveRichard MacCutchan16-Jul-14 23:54 
AnswerRe: how to select numbers (integers) only? Pin
thatraja17-Jul-14 0:01
professionalthatraja17-Jul-14 0:01 
AnswerRe: how to select numbers (integers) only? Pin
Mycroft Holmes17-Jul-14 13:49
professionalMycroft Holmes17-Jul-14 13:49 
AnswerRe: how to select numbers (integers) only? Pin
PIEBALDconsult17-Jul-14 14:52
professionalPIEBALDconsult17-Jul-14 14:52 
GeneralRe: how to select numbers (integers) only? Pin
Jassim Rahma19-Jul-14 23:17
Jassim Rahma19-Jul-14 23:17 
GeneralRe: how to select numbers (integers) only? Pin
PIEBALDconsult20-Jul-14 5:50
professionalPIEBALDconsult20-Jul-14 5:50 
QuestionHandle to chat room with mysql database Pin
Member 1094998616-Jul-14 5:08
Member 1094998616-Jul-14 5:08 
AnswerRe: Handle to chat room with mysql database Pin
Eddy Vluggen16-Jul-14 6:02
professionalEddy Vluggen16-Jul-14 6:02 
Delete the recipient-table, and add a table like below;

DeletedMessagesPerUser
UserId
MessageId

Add a record to that table when the user "deletes" a message. When fetching all messages for a particular user, fetch all messages where the messageId isn't named in the DeletedMessagesPerUser table.
Bastard Programmer from Hell Suspicious | :suss:
If you can't read my code, try converting it here[^]

GeneralRe: Handle to chat room with mysql database Pin
Member 1094998616-Jul-14 8:18
Member 1094998616-Jul-14 8:18 
GeneralRe: Handle to chat room with mysql database Pin
Eddy Vluggen16-Jul-14 8:46
professionalEddy Vluggen16-Jul-14 8:46 
GeneralRe: Handle to chat room with mysql database Pin
Member 1094998616-Jul-14 8:53
Member 1094998616-Jul-14 8:53 
GeneralRe: Handle to chat room with mysql database Pin
Eddy Vluggen16-Jul-14 9:05
professionalEddy Vluggen16-Jul-14 9:05 
GeneralRe: Handle to chat room with mysql database Pin
Member 1094998616-Jul-14 9:09
Member 1094998616-Jul-14 9:09 
GeneralRe: Handle to chat room with mysql database Pin
Eddy Vluggen16-Jul-14 9:24
professionalEddy Vluggen16-Jul-14 9:24 
AnswerRe: Handle to chat room with mysql database Pin
data modeling guy16-Jul-14 18:42
data modeling guy16-Jul-14 18:42 
GeneralRe: Handle to chat room with mysql database Pin
Member 1094998616-Jul-14 22:28
Member 1094998616-Jul-14 22:28 
GeneralRe: Handle to chat room with mysql database Pin
data modeling guy17-Jul-14 0:52
data modeling guy17-Jul-14 0:52 
GeneralRe: Handle to chat room with mysql database Pin
Member 1094998617-Jul-14 2:45
Member 1094998617-Jul-14 2:45 
QuestionSSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER Pin
Mangesh678616-Jul-14 3:04
Mangesh678616-Jul-14 3:04 
AnswerRe: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER Pin
Eddy Vluggen16-Jul-14 6:03
professionalEddy Vluggen16-Jul-14 6:03 
AnswerRe: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER Pin
PIEBALDconsult17-Jul-14 14:39
professionalPIEBALDconsult17-Jul-14 14:39 
QuestionExtract Data in Single Record Pin
mrfalk15-Jul-14 14:05
mrfalk15-Jul-14 14:05 
AnswerRe: Extract Data in Single Record Pin
data modeling guy15-Jul-14 20:32
data modeling guy15-Jul-14 20:32 
AnswerRe: Extract Data in Single Record Pin
Richard Deeming16-Jul-14 3:42
mveRichard Deeming16-Jul-14 3:42 
AnswerRe: Extract Data in Single Record Pin
PIEBALDconsult17-Jul-14 14:54
professionalPIEBALDconsult17-Jul-14 14:54 

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.