Click here to Skip to main content
16,017,319 members
Home / Discussions / Visual Basic
   

Visual Basic

 
GeneralRe: Insert timestamp using datareader to oracle date Pin
kerek229-Oct-20 14:11
kerek229-Oct-20 14:11 
GeneralRe: Insert timestamp using datareader to oracle date Pin
Dave Kreskowiak29-Oct-20 14:13
mveDave Kreskowiak29-Oct-20 14:13 
GeneralRe: Insert timestamp using datareader to oracle date Pin
Victor Nijegorodov27-Oct-20 21:11
Victor Nijegorodov27-Oct-20 21:11 
GeneralRe: Insert timestamp using datareader to oracle date Pin
DerekT-P7-Oct-20 23:39
professionalDerekT-P7-Oct-20 23:39 
GeneralRe: Insert timestamp using datareader to oracle date Pin
kerek211-Oct-20 17:14
kerek211-Oct-20 17:14 
QuestionCreate an assignment operator that accepts as const value: CLOSED Pin
mo149230-Sep-20 5:36
mo149230-Sep-20 5:36 
Questionselect MIN(Date) value and other data from multiple table Pin
kerek228-Sep-20 22:46
kerek228-Sep-20 22:46 
SuggestionRe: select MIN(Date) value and other data from multiple table Pin
Richard Deeming29-Sep-20 0:10
mveRichard Deeming29-Sep-20 0:10 
kerek2 wrote:
"WHERE CARDHOLDERID ='" + IBSSDR.Item("CARDHOLDERID") + "' "

NEVER use string concatenation to build a SQL query. ALWAYS use a parameterized query.

Everything you wanted to know about SQL injection (but were afraid to ask) | Troy Hunt[^]
How can I explain SQL injection without technical jargon? | Information Security Stack Exchange[^]
Query Parameterization Cheat Sheet | OWASP[^]

VB.NET
Using FBCMD As New FbCommand("UPDATE EVENT SET PRIORITY = '1' WHERE CARDHOLDERID = @CARDHOLDERID AND  EVENTDATE >= CAST('TODAY' AS DATE) AND EVENTMSG = 'Access Granted'", IBSSCN)
    FBCMD.Parameters.AddWithValue("@CARDHOLDERID", IBSSDR.Item("CARDHOLDERID"))
    FBCMD.ExecuteNonQuery()
End Using




"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer

GeneralRe: select MIN(Date) value and other data from multiple table Pin
kerek230-Sep-20 21:17
kerek230-Sep-20 21:17 
GeneralRe: select MIN(Date) value and other data from multiple table Pin
Richard Deeming30-Sep-20 22:03
mveRichard Deeming30-Sep-20 22:03 
AnswerRe: select MIN(Date) value and other data from multiple table Pin
DerekT-P29-Sep-20 7:37
professionalDerekT-P29-Sep-20 7:37 
AnswerRe: select MIN(Date) value and other data from multiple table Pin
Gerry Schmitz1-Oct-20 5:36
mveGerry Schmitz1-Oct-20 5:36 
QuestionChanging of date format problem upon retrieving in date field Pin
Member 1494895025-Sep-20 20:39
Member 1494895025-Sep-20 20:39 
AnswerRe: Changing of date format problem upon retrieving in date field Pin
Victor Nijegorodov25-Sep-20 21:11
Victor Nijegorodov25-Sep-20 21:11 
GeneralRe: Changing of date format problem upon retrieving in date field Pin
Member 1494895025-Sep-20 21:19
Member 1494895025-Sep-20 21:19 
GeneralRe: Changing of date format problem upon retrieving in date field Pin
Dave Kreskowiak26-Sep-20 5:49
mveDave Kreskowiak26-Sep-20 5:49 
AnswerRe: Changing of date format problem upon retrieving in date field Pin
Richard MacCutchan25-Sep-20 22:02
mveRichard MacCutchan25-Sep-20 22:02 
GeneralRe: Changing of date format problem upon retrieving in date field Pin
Member 1494895025-Sep-20 22:28
Member 1494895025-Sep-20 22:28 
GeneralRe: Changing of date format problem upon retrieving in date field Pin
Richard MacCutchan25-Sep-20 22:44
mveRichard MacCutchan25-Sep-20 22:44 
GeneralRe: Changing of date format problem upon retrieving in date field Pin
Member 1494895025-Sep-20 22:57
Member 1494895025-Sep-20 22:57 
GeneralRe: Changing of date format problem upon retrieving in date field Pin
Richard MacCutchan25-Sep-20 23:16
mveRichard MacCutchan25-Sep-20 23:16 
GeneralRe: Changing of date format problem upon retrieving in date field Pin
Dave Kreskowiak26-Sep-20 5:59
mveDave Kreskowiak26-Sep-20 5:59 
QuestionAccessing a known Outlook subfolder Pin
Member 1205805425-Sep-20 1:25
Member 1205805425-Sep-20 1:25 
AnswerRe: Accessing a known Outlook subfolder Pin
Sandeep Mewara25-Sep-20 3:26
mveSandeep Mewara25-Sep-20 3:26 
GeneralRe: Accessing a known Outlook subfolder Pin
Member 1205805425-Sep-20 4:25
Member 1205805425-Sep-20 4:25 

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.