Click here to Skip to main content
16,016,623 members
Home / Discussions / Database
   

Database

 
AnswerRe: Check for object existence sql server 2012 is creating stored procedure as dynamic sql Pin
Richard Deeming26-Jun-18 1:50
mveRichard Deeming26-Jun-18 1:50 
QuestionPDO/mySQL/PHP - when is it OK to NOT use parameter binding, when should I REALLY use it? Pin
needAbreakNow17-Jun-18 16:13
needAbreakNow17-Jun-18 16:13 
AnswerRe: PDO/mySQL/PHP - when is it OK to NOT use parameter binding, when should I REALLY use it? Pin
Jörgen Andersson17-Jun-18 19:29
professionalJörgen Andersson17-Jun-18 19:29 
AnswerRe: PDO/mySQL/PHP - when is it OK to NOT use parameter binding, when should I REALLY use it? Pin
Mycroft Holmes17-Jun-18 20:43
professionalMycroft Holmes17-Jun-18 20:43 
AnswerRe: PDO/mySQL/PHP - when is it OK to NOT use parameter binding, when should I REALLY use it? Pin
Eddy Vluggen18-Jun-18 0:27
professionalEddy Vluggen18-Jun-18 0:27 
AnswerRe: PDO/mySQL/PHP - when is it OK to NOT use parameter binding, when should I REALLY use it? Pin
jschell23-Jun-18 5:12
jschell23-Jun-18 5:12 
QuestionPDO Get Previous and Next Record partially working Pin
needAbreakNow16-Jun-18 21:19
needAbreakNow16-Jun-18 21:19 
AnswerRe: PDO Get Previous and Next Record partially working Pin
Richard MacCutchan16-Jun-18 21:32
mveRichard MacCutchan16-Jun-18 21:32 
I am not a SQL expert, but the following occurs to me. Your SELECT statement says: find all records whose article_id is less than the value given (i.e. 47), and return the first record found. So SQL starts searching the table at the beginning, checks the first record and its id is 24, and that matches your search criteria. In order to do what you want you need somehow to tell it to find the record with the highest id that is less than 47. But I am not sure how you would specify that.
AnswerRe: PDO Get Previous and Next Record partially working Pin
Victor Nijegorodov16-Jun-18 22:45
Victor Nijegorodov16-Jun-18 22:45 
AnswerRe: PDO Get Previous and Next Record partially working Pin
needAbreakNow16-Jun-18 23:06
needAbreakNow16-Jun-18 23:06 
GeneralRe: PDO Get Previous and Next Record partially working Pin
Richard MacCutchan17-Jun-18 1:11
mveRichard MacCutchan17-Jun-18 1:11 
GeneralArgus Pin
Keith@Stand15-Jun-18 4:17
Keith@Stand15-Jun-18 4:17 
GeneralRe: Argus Pin
CHill6015-Jun-18 4:21
mveCHill6015-Jun-18 4:21 
GeneralRe: Argus Pin
jschell23-Jun-18 5:17
jschell23-Jun-18 5:17 
QuestionCode Expert Pin
Keith@Stand7-Jun-18 8:13
Keith@Stand7-Jun-18 8:13 
AnswerRe: Code Expert Pin
OriginalGriff7-Jun-18 8:16
mveOriginalGriff7-Jun-18 8:16 
AnswerRe: Code Expert Pin
Swinkaran7-Jun-18 18:39
professionalSwinkaran7-Jun-18 18:39 
GeneralRe: Code Expert Pin
Keith@Stand7-Jun-18 19:18
Keith@Stand7-Jun-18 19:18 
GeneralRe: Code Expert Pin
Mycroft Holmes17-Jun-18 20:51
professionalMycroft Holmes17-Jun-18 20:51 
GeneralRe: Code Expert Pin
jschell23-Jun-18 5:21
jschell23-Jun-18 5:21 
AnswerRe: Code Expert Pin
Christopher Stewart27-Jun-18 10:47
Christopher Stewart27-Jun-18 10:47 
QuestionRunning the Package in different versions of SQL Server Pin
indian1434-Jun-18 10:34
indian1434-Jun-18 10:34 
AnswerRe: Running the Package in different versions of SQL Server Pin
Mycroft Holmes4-Jun-18 14:10
professionalMycroft Holmes4-Jun-18 14:10 
Questiontrying to follow this tutorial but video not set at 100% Pin
piano00112-Jun-18 18:14
piano00112-Jun-18 18:14 
AnswerRe: trying to follow this tutorial but video not set at 100% Pin
OriginalGriff2-Jun-18 18:48
mveOriginalGriff2-Jun-18 18:48 

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.