Hi everyone.... Im back.. i need ur help...
can u give me the best MYSQL TUTORIAL? especially those with broad tutorials on SELECT STATEMENTS... Thank You very Much.....
<I would appreciate if you give me a detailed tutorials>
Thank you!
obkfixx
Last Activity: Dec 8 '08, 08:10 PM
Joined: Mar 13 '08
Location:
-
Guys....MYSQL QUERY TUTORIALS
-
Try this:
Private Sub cmdDelete_Click ()
Dim cn As New ADODB.Connectio n
cn.ConnectionSt ring = "DSN=Agents "
Dim rs As New ADODB.Recordset
cn.Open
Set rs = cn.Execute( "Delete * from Agentinfo where AGENTID = '"& txtAgtId.Text &"'")
MsgBox ("Record successfully deleted")
txtAgtId.Text = ""... -
how do you catch non alphanumeric characters?
help.. i have a problem.. how do u catch non alphanumeric characters??
it created an error on my program since the field type on the database is varchar...
when i inputed admin\ on the username.... it creates a runtime error -
How to print datareport without previewing first
help! how do u print a datareport without showing the datareport??? u print it automatically.. ... but the format n ur data report will be printed except that u dont show it. -
Thanks iT helped a lot......
regArds! OBKFixx...Leave a comment:
-
this is the code:
[CODE=vb]Public Sub createConnectio n()
Set condb = New adodb.Connectio n
condb.Connectio nTimeout = 60
condb.CommandTi meout = 400
condb.CursorLoc ation = adUseClient
condb.Connectio nString = "User ID=root;Data Source=HRBS;DAT ABASE=hostel;DS N=HRBS;OPTION=0 ;PORT=3306;SERV ER=localhost;UI D=root"""
condb.Open
End Sub
[/CODE]
...Leave a comment:
-
Ooooooooh! thanks. but it didnt help..... i need to find out if the input of the textbox are all white spaces.. or spaces.... cud u write me a code for this?...Leave a comment:
-
how do u recognize space on textbox
help! how do u recognize a space on the textbox? -
-
-
heeeeeeeeeeeeeeelp!
help please.. i need to get a number converted into words.. for example
100 = one hundred .. 10 = ten.... 1000 = one thousand.....
could u give me a vb built in function for this? or a code?? -
here are the code for displaying receipt.. but the listview here is not included since i dont know how....
[CODE=vb]
Set rsservice = condb.Execute(" select custid from service where custid = '" & custID & "'")
If rsservice.Recor dCount > 0 Then
Set rsreport = condb.Execute(" SELECT statementofacco unt.DateDone,st atementofaccoun t.ORNum,stateme ntofaccount.Tot alAmt,billcode. Amount...Leave a comment:
-
yup i have.. it is named as HRBS...Leave a comment:
-
i dont have any codes yet.. i dont have any idea... haaay...Leave a comment:
-
hi there. im using mysql.. navicat... huhuhu.. heeeeeeelp!...Leave a comment:
-
Include listview in datareport
hello.. help me please. i have a problem.... here it is...
i have a listview of services and i want all of those list to be in a datareport....h elp me how to do that please!.... thankssss... reply people asap -
Create database connection
hi.. help me please create a connection
we have a server where i have the database on it.
yet i dont know how to make connection to that database.
it always says error on connection..... . how do i set up the connection string? -
ooooh. thanks.. its like.... ahmm i could just ahm execute a batch file in navicat? is that what u mean??...Leave a comment:
-
Import/export MySQL database
hi everyone im new here.. and ive got this problem... actually im a newbie in programming so.. im gonna need every ounce of help. so here goes :
i have a database in my localhost named hostel. But our instructor says to put that database or provide a copy of that database to the server. how do i dump a db on a navicat then put it on the server???
I am a computer science student.... help me! please...
No activity results to display
Leave a comment: