Click here to Skip to main content
       

Visual Basic

 
GeneralRe: Question about variables in Classic ASP VBScript PinmemberChandraRam8-Oct-12 3:23 
GeneralRe: Question about variables in Classic ASP VBScript PinmemberDiego Carrion8-Oct-12 3:26 
GeneralRe: Question about variables in Classic ASP VBScript PinmemberZac Greve7-Oct-12 7:39 
GeneralRe: Question about variables in Classic ASP VBScript PinmvpDave Kreskowiak7-Oct-12 9:15 
GeneralRe: Question about variables in Classic ASP VBScript PinmemberDiego Carrion7-Oct-12 10:25 
GeneralRe: Question about variables in Classic ASP VBScript PinmvpDave Kreskowiak7-Oct-12 11:11 
GeneralRe: Question about variables in Classic ASP VBScript PinmemberDiego Carrion7-Oct-12 11:23 
Questionerror Pinmemberuday87227-Oct-12 4:22 
AnswerRe: error PinmvpRichard MacCutchan7-Oct-12 5:47 
GeneralRe: error PinmvpOriginalGriff7-Oct-12 6:44 
GeneralRe: error PinmvpRichard MacCutchan7-Oct-12 7:39 
QuestionSQL Query for dates PinmemberSPSandy7-Oct-12 3:17 
AnswerRe: SQL Query for dates PinmvpRichard MacCutchan7-Oct-12 5:50 
AnswerRe: SQL Query for dates PinmemberEddy Vluggen8-Oct-12 3:37 
SPSandy wrote:
This will not work since TBL_DATE1 is a VARCHAR Type

Cry | :((
  • Dates are stored as a date, not as a varchar. That's what needs to be changed, not the query; converting the varchar to a date to do a comparison is a dirty hack, trying to work around a previous mistake. (If you move the database or the culture changes, things will break.)
  • It's recommended to sanitize the query; use a DbParameter, the way it's now I could destroy your database.
Bastard Programmer from Hell Suspicious | :suss:
if you can't read my code, try converting it here[^]

GeneralRe: SQL Query for dates PinmemberJohan Hakkesteegt11-Oct-12 0:38 
GeneralRe: SQL Query for dates PinmemberSPSandy15-Oct-12 5:32 
AnswerRe: SQL Query for dates PinmemberEddy Vluggen15-Oct-12 5:54 
GeneralRe: SQL Query for dates PinmemberSPSandy15-Oct-12 7:05 
QuestionConverting fromVB.NET to C PinmemberMember 94911027-Oct-12 2:54 
AnswerRe: Converting fromVB.NET to C PinmemberWes Aday7-Oct-12 2:57 
QuestionAdditional properties or methods into midi form of VB6.0? PinmemberMember 24584675-Oct-12 21:37 
AnswerRe: Additional properties or methods into midi form of VB6.0? Pinmemberjan212r6-Oct-12 0:14 
GeneralRe: Additional properties or methods into midi form of VB6.0? PinmemberMember 24584676-Oct-12 4:54 
AnswerRe: Additional properties or methods into midi form of VB6.0? PinmemberEddy Vluggen6-Oct-12 4:50 
GeneralRe: Additional properties or methods into midi form of VB6.0? PinmemberMember 24584676-Oct-12 5:02 
GeneralRe: Additional properties or methods into midi form of VB6.0? PinmemberEddy Vluggen7-Oct-12 2:28 
QuestionSecuring application password PinmemberDisIsHoody4-Oct-12 13:26 
AnswerRe: Securing application password PinmvpRichard MacCutchan4-Oct-12 22:54 
AnswerRe: Securing application password PinmemberDavid Mujica5-Oct-12 4:11 
AnswerRe: Securing application password PinmemberDisIsHoody5-Oct-12 10:58 
GeneralRe: Securing application password PinmvpRichard MacCutchan5-Oct-12 23:40 
AnswerRe: Securing application password PinmemberMatty2211-Oct-12 18:29 
GeneralRe: Securing application password PinmemberDisIsHoody11-Oct-12 19:51 
GeneralRe: Securing application password PinmemberMatty2211-Oct-12 20:05 
GeneralRe: Securing application password PinmemberMatty2211-Oct-12 20:11 
GeneralRe: Securing application password PinmemberDisIsHoody12-Oct-12 10:28 
GeneralRe: Securing application password PinmemberMatty2212-Oct-12 14:53 
GeneralRe: Securing application password PinmemberDisIsHoody12-Oct-12 19:59 
QuestionVB6 Project - Printing Press Management System PinmemberMahesh KL3-Oct-12 6:58 
AnswerRe: VB6 Project - Printing Press Management System PinmvpDave Kreskowiak3-Oct-12 14:39 
AnswerRe: VB6 Project - Printing Press Management System PinmemberEddy Vluggen3-Oct-12 23:49 
SuggestionRe: VB6 Project - Printing Press Management System PinmemberJoan Murt4-Oct-12 1:47 
QuestionWorking from scratch based on created application PinmemberHerboren3-Oct-12 6:49 
AnswerRe: Working from scratch based on created application PinmemberEddy Vluggen3-Oct-12 23:46 
AnswerRe: Working from scratch based on created application PinmemberDisIsHoody11-Oct-12 20:02 
QuestionHow may I add a MDITabControl to my project (VB2008) PinmemberMember 16752941-Oct-12 5:56 
AnswerRe: How may I add a MDITabControl to my project (VB2008) PinmemberEddy Vluggen1-Oct-12 6:14 
QuestionLOAD CSV FILES TO VB 8 Pinmembermemas6328-Sep-12 7:32 
AnswerRe: LOAD CSV FILES TO VB 8 PinmvpDave Kreskowiak28-Sep-12 8:03 
QuestionSOAP service responding with partial data Pinmemberloctrice28-Sep-12 6:17 

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

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


Advertise | Privacy | Mobile
Web02 | 2.8.141216.1 | Last Updated 17 Dec 2014
Copyright © CodeProject, 1999-2014
All Rights Reserved. Terms of Service
Layout: fixed | fluid