I just added this line on my stored proc and it worked wonderfully.
SELECT @unamex = RTRIM(@unamex) + '%'
chuckzter
Last Activity: Jan 20 '12, 09:41 PM
Joined: Oct 2 '07
Location:
-
I almost forgot to mention that tbl_UserPro on my stored procedure where i get all my data is not really a table but i created it from "Views" i'm not really sure if that helps, but i'm looking on it.Leave a comment:
-
Returning value from Like statement in SQL server 2008 to vb.net
I'm in a bit of a pickle here. I need to pass the variable @uname which gets a value from a text box to a statement on one of my stored procedures in SQL server and return an output on my form.
Here is the code:
in .net
...Code:cmd = New SqlCommand cmd.CommandText = "sp_TransData" cmd.CommandType = CommandType.StoredProcedure cmd.Parameters.Add("@unamex",SqlDbType.VarChar,15) -
chuckzter replied to Is there any way to connect to my database(.mdb) without setting up a reference?in Visual BasicSounds great, i googled it and it might be the answer to my question. Thanks!Leave a comment:
-
chuckzter replied to Is there any way to connect to my database(.mdb) without setting up a reference?in Visual BasicOkay, for future reference anyone?
Thanks in advance.Leave a comment:
-
chuckzter started a topic Is there any way to connect to my database(.mdb) without setting up a reference?in Visual BasicIs there any way to connect to my database(.mdb) without setting up a reference?
The one that i'm using is Microsoft ActiveX Data Objects 2.8 Library.
Also, compiling the whole program is not a choice since that already takes care of the reference list.
I have 3 hours. Help anyone?
Thanks in advance. -
Got it. I just had to upload my files to the server itself where my mysql is sitting. Thanks for all those who replied.
Just to give a heads up, i might posting other questions in the near future. :p
I just love bytes.Leave a comment:
-
I'm using host-ed.net.
I'm not really sure checking on the "overview" for the free sign up right now. Also, i consulted someone from my school to try another free mysql hosting site just in case the one that's causing the problem is the host itself. I'll try to give you an update a little bit later.
Note:
Don't consider the site i listed above to be an advertisement, just wanted to know if somebody...Leave a comment:
-
Here you go.
...Code:<?php $con = mysql_connect("82.197.130.38","319770_gwonder","*****"); if (!$con) { die('Could not connect: ' . mysql_error()); } mysql_select_db("319770_gwonder", $con); $sql="INSERT INTO reg_Userdb (user_Fname, user_Lname, user_Age, user_Etc) VALUES ('$_POST[fname]','$_POST[lname]','$_POST[age]','$_POST[ea]')";Leave a comment:
-
How to connect to mysql online database
Greetings,
I'm having this error , Can't connect to MySQL server on '_______' (10061)
I have a lot of questions running in my head right now,
first is, the '___' on top, should it be an ip of the server?
also, should i have my php and html file uploaded?
What i'm actually trying to do is do an insert command to my mysql database, I don't have my html file and php file uploaded,... -
Please guide me if the topic said above is possible.Leave a comment:
-
I plan on creating a 3d object on 3dsmax and import it to vb 6.0 and add effects to it. (moving, etc). But the movement for example is only triggered by a event, repeating. ie. (turning logo, 360 deg during mouse over).
I thought of using a gif effect but i am curious if the method above is possible.Leave a comment:
-
importing 3D
Greetings,
I would like to know if it is possible to import a 3d object unto a vb 6.0 platform. If yes, how? What tools would be needed? Thanks in advance. -
It's a hypothetical question.Leave a comment:
-
Online Database
I would like to ask if it is possible to connect to an online database with the use of visual basic 6.0? or rather can i use visual basic 6.0 as a platform for an online database? If yes, how? Thanks in advance. -
I'm using visual basic 6.0.
Can anybody give me a brief explanation on how to manipulate or use the listview effectively?
@Poster above me:
I've seen that page before, still i can't get what i want to achieve. Help please.Leave a comment:
-
Listview
Greetings,
I would like to know how to get values from a listview with it having 5 columns. And How to insert values unto it. It's so much different than listbox. I've been doing a lot of searching but alas, no luck on finding what i am looking for. Thanks in advance. -
Problem resolved, thanks.Leave a comment:
-
-
Our senior programmer fixed the problem. Thanks for all the replies.Leave a comment:
No activity results to display
Leave a comment: