Click here to Skip to main content
15,900,108 members
Home / Discussions / Visual Basic
   

Visual Basic

 
AnswerRe: Build Error Message Pin
CPallini3-Jan-07 21:55
mveCPallini3-Jan-07 21:55 
QuestionNotecard Program Pin
sh3l13-Jan-07 13:39
sh3l13-Jan-07 13:39 
AnswerRe: Notecard Program Pin
CPallini3-Jan-07 21:41
mveCPallini3-Jan-07 21:41 
QuestionRe: Notecard Program [modified] Pin
sh3l14-Jan-07 13:41
sh3l14-Jan-07 13:41 
QuestionPolymorphism/Inheritance question Pin
dukesys3-Jan-07 11:44
dukesys3-Jan-07 11:44 
AnswerRe: Polymorphism/Inheritance question Pin
CPallini3-Jan-07 21:38
mveCPallini3-Jan-07 21:38 
GeneralRe: Polymorphism/Inheritance question Pin
dukesys4-Jan-07 11:54
dukesys4-Jan-07 11:54 
Questionformat date in MySql Pin
jds12073-Jan-07 10:07
jds12073-Jan-07 10:07 
I need to format the date when the values are inserted to the MySQl db. All other columns work fine but all of the date columns are inserted as zeroes and in a different format, for example 0000-00-00. Any ideas?

Code:
Dim myConnString As String = "DRIVER={MySQL ODBC 3.51 Driver};" & _
"SERVER=192.168.1.27;" & _
"DATABASE=testship;" & _
"USER=;" & _
"PASSWORD=;" & _
"OPTION=3;"

Dim MyConnection As New Odbc.OdbcConnection(myConnString)
MyConnection.Open()
Dim MyCommand As New Odbc.OdbcCommand
MyCommand.Connection = MyConnection
MyCommand.CommandText = "INSERT INTO ls_orderitems (OrderDate, OrderCustomer, OrderAcctNum, OrderType, OrderSoNum, OrderItemPartNum, OrderItemPartDesc, OrderItemQty, OrderItemQtyRec, OrderItemQtyDtRec, OrderItemBO, OrderItemBODt,OrderItemCanceled, OrderItemCanceledDt, OrderItemNotes, OrderItemPONum, OrderItemRetailPrice, OrderItemSalePrice, Status, InsertDate) VALUES ('" & OrderDate & "','" & OrderCustomer & "','" & OrderAcctNum & "','" & OrderType & "','" & OrderSoNum & "','" & OrderItemPartNum & "','" & OrderItemPartDesc & "','" & OrderItemQty & "','" & OrderItemQtyRec & "','" & OrderItemQtyDtRec & "','" & OrderItemBO & "','" & OrderItemBODt & "','" & OrderItemCanceled & "','" & OrderItemCanceledDt & "','" & OrderItemNotes & "','" & OrderItemPONum & "','" & OrderItemRetailPrice & "','" & OrderItemSalePrice & "','" & Status & "','" & InsertDate & "'" & ")" '& "','" & 'TimeStamp & "'" & ")"

MyCommand.ExecuteNonQuery()
MyConnection.Close()
AnswerRe: format date in MySql Pin
Dave Kreskowiak3-Jan-07 11:40
mveDave Kreskowiak3-Jan-07 11:40 
GeneralRe: format date in MySql Pin
jds12074-Jan-07 3:59
jds12074-Jan-07 3:59 
GeneralRe: format date in MySql Pin
jds12074-Jan-07 5:27
jds12074-Jan-07 5:27 
QuestionPerformance with Editor Pin
Cecil Cheah3-Jan-07 10:00
Cecil Cheah3-Jan-07 10:00 
AnswerRe: Performance with Editor Pin
Enriad4-Jan-07 2:47
Enriad4-Jan-07 2:47 
QuestionVB6 to VB.NET printing using Printer Language Pin
oogyboogyme3-Jan-07 8:18
oogyboogyme3-Jan-07 8:18 
AnswerRe: VB6 to VB.NET printing using Printer Language Pin
MatrixCoder3-Jan-07 8:40
MatrixCoder3-Jan-07 8:40 
AnswerRe: VB6 to VB.NET printing using Printer Language Pin
oogyboogyme3-Jan-07 8:51
oogyboogyme3-Jan-07 8:51 
AnswerRe: VB6 to VB.NET printing using Printer Language Pin
Tim Carmichael3-Jan-07 10:17
Tim Carmichael3-Jan-07 10:17 
GeneralRe: VB6 to VB.NET printing using Printer Language Pin
oogyboogyme4-Jan-07 13:00
oogyboogyme4-Jan-07 13:00 
GeneralRe: VB6 to VB.NET printing using Printer Language Pin
Tim Carmichael5-Jan-07 2:41
Tim Carmichael5-Jan-07 2:41 
QuestionEngineering problem-please advise Pin
neobavesten3-Jan-07 6:10
neobavesten3-Jan-07 6:10 
GeneralRe: Engineering problem-please advise Pin
nagendra rao s.v.3-Jan-07 20:07
nagendra rao s.v.3-Jan-07 20:07 
QuestionMySql connection Pin
jds12073-Jan-07 5:59
jds12073-Jan-07 5:59 
AnswerRe: MySql connection Pin
Dave Kreskowiak3-Jan-07 6:34
mveDave Kreskowiak3-Jan-07 6:34 
AnswerRe: MySql connection Pin
jds12073-Jan-07 7:17
jds12073-Jan-07 7:17 
GeneralRe: MySql connection Pin
Dave Kreskowiak3-Jan-07 7:22
mveDave Kreskowiak3-Jan-07 7:22 

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.