Click here to Skip to main content
15,898,978 members
Home / Discussions / Visual Basic
   

Visual Basic

 
QuestionDateTime Format Pin
himuskanhere20-Jun-07 18:31
himuskanhere20-Jun-07 18:31 
AnswerRe: DateTime Format Pin
Revathij20-Jun-07 22:18
Revathij20-Jun-07 22:18 
AnswerRe: DateTime Format Pin
AlexeiXX321-Jun-07 5:16
AlexeiXX321-Jun-07 5:16 
QuestionPrinting in vb.net Pin
MashALyy20-Jun-07 18:29
MashALyy20-Jun-07 18:29 
AnswerRe: Printing in vb.net Pin
Rupesh Kumar Swami20-Jun-07 21:21
Rupesh Kumar Swami20-Jun-07 21:21 
Questionexport /import data to excel with VB.Net(VB) Pin
warwarphoo20-Jun-07 17:44
warwarphoo20-Jun-07 17:44 
AnswerRe: export /import data to excel with VB.Net(VB) Pin
Sanjay Kunjam20-Jun-07 23:13
Sanjay Kunjam20-Jun-07 23:13 
QuestionMysql update - STUCK Pin
LegionFX20-Jun-07 17:31
LegionFX20-Jun-07 17:31 
can somemone translate this MYSQL command to vb.net?

UPDATE `phpbb_config` SET `config_value` = 'NEW DATA' WHERE CONVERT( `config_name` USING utf8 ) = 'newest_username' LIMIT 1 ;

i need to change the "NEW DATA" part.


this is the string i have but it doenst work :
myCommand.CommandText = "UPDATE phpbb_config SET config_value = ?user WHERE CONVERT( config_name USING utf8 ) = newest_username LIMIT 1"
myCommand.Parameters.AddWithValue("?user", username.Text)

cheers


oh and the table looks like this.

database == phpbb , table == phpbb_config , colum ==config_value,,config_name,,is_dynamic
so is the config_name value i want to change, in the 3 colums exists something like 30 records, 4example -
Config_name ---- Config_value --- is_dynamic
activesessions 0 0
record_onlineusers 36 1
newest_username newuser 1 ---->>>> this is the one i want to change

im repeating myself because im stuck. lol
please help
hope someone understand this. lol






AnswerRe: Mysql update - STUCK Pin
Christian Graus20-Jun-07 19:21
protectorChristian Graus20-Jun-07 19:21 
GeneralRe: Mysql update - STUCK Pin
LegionFX21-Jun-07 5:04
LegionFX21-Jun-07 5:04 
AnswerRe: How to store from listbox to array in vb.net Pin
Sanjay Kunjam20-Jun-07 21:13
Sanjay Kunjam20-Jun-07 21:13 
GeneralRe: How to store from listbox to array in vb.net Pin
Kanwal0921-Jun-07 22:09
Kanwal0921-Jun-07 22:09 
Questionvb6 with crystal report 8.5 Pin
Nine_20-Jun-07 16:43
Nine_20-Jun-07 16:43 
AnswerRe: vb6 with crystal report 8.5 Pin
Tirthadip20-Jun-07 21:50
Tirthadip20-Jun-07 21:50 
GeneralRe: vb6 with crystal report 8.5 Pin
Nine_20-Jun-07 22:34
Nine_20-Jun-07 22:34 
GeneralRe: vb6 with crystal report 8.5 Pin
Dave Kreskowiak21-Jun-07 4:24
mveDave Kreskowiak21-Jun-07 4:24 
QuestionVB Timer and XML read/write question Pin
commieJerk20-Jun-07 16:00
commieJerk20-Jun-07 16:00 
AnswerRe: VB Timer and XML read/write question Pin
Dave Kreskowiak21-Jun-07 4:22
mveDave Kreskowiak21-Jun-07 4:22 
GeneralRe: VB Timer and XML read/write question Pin
commieJerk21-Jun-07 4:48
commieJerk21-Jun-07 4:48 
GeneralRe: VB Timer and XML read/write question Pin
Dave Kreskowiak21-Jun-07 14:20
mveDave Kreskowiak21-Jun-07 14:20 
GeneralRe: VB Timer and XML read/write question Pin
commieJerk22-Jun-07 3:42
commieJerk22-Jun-07 3:42 
GeneralRe: VB Timer and XML read/write question Pin
Dave Kreskowiak22-Jun-07 16:47
mveDave Kreskowiak22-Jun-07 16:47 
Questionpicture appearing in VB 2005 express edition Pin
ali3nz0r20-Jun-07 14:43
ali3nz0r20-Jun-07 14:43 
AnswerRe: picture appearing in VB 2005 express edition Pin
_Damian S_20-Jun-07 14:56
professional_Damian S_20-Jun-07 14:56 
AnswerRe: picture appearing in VB 2005 express edition Pin
Christian Graus20-Jun-07 15:07
protectorChristian Graus20-Jun-07 15:07 

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.