|
What is the erorr with this select statement
Set RS = DB.OpenRecordset("select * from Users where User_name=" & Text1.Text & " and User_pass=" & Text2.Text & " and User_type=" & Combo1.List(Combo1.ListIndex))
I use it in vb6 with DAO 3.5
but the compiler tell that too few parameter.Expected 2
all these fields in the table is text
please help
thanx
BE OR NOT TO BE
|
|
|
|
|
You are missin single quotes around the sring values (Text1.Text, Text2.Text) so they are treated as symbolic names for parameters: (extra spaces around ' not needed)
"select * from Users where User_name= ' " & Text1.Text & " ' and User_pass= ' " & Text2.Text & " ' and
|
|
|
|
|
Hello !
Can anybody help me ?
I'm interested to develop an application that uses MySql.Data.dll at runtime with reflection. I got a NullReferenceException when I try to set the value of SelectCommand in MySql.Data.MySqlClient.MySqlDataAdapter namespace.
I don't understand why, I've used Activator.CreateInstance....
Here It is the code of my app:
Dim asm As Assembly = Assembly.LoadFrom("C:\MySql.Data.dll")
Dim myConnectionString As String
myConnectionString = "server=localhost;" _
& "uid=root;" _
& "pwd=xxxxxxx;" _
& "database=test;"
Dim params() As Object = {myConnectionString}
Dim MySqlConnectionClass As Object = Activator.CreateInstance(asm.GetType("MySql.Data.MySqlClient.MySqlConnection"), params)
Dim t As Type = MySqlConnectionClass.GetType
Dim MySqlDataAdapterClass As Object = Activator.CreateInstance(asm.GetType("MySql.Data.MySqlClient.MySqlDataAdapter"))
Dim t2 As Type = MySqlDataAdapterClass.GetType
Dim params2() As Object = {"SELECT * FROM WEB_USER WHERE UserName= 'test' AND Password = 'test'", MySqlConnectionClass}
Dim MySqlCommandClass As Object = Activator.CreateInstance(asm.GetType("MySql.Data.MySqlClient.MySqlCommand"), params2)
Dim t3 As Type = MySqlCommandClass.GetType
Dim mi As PropertyInfo = t2.GetProperty("SelectCommand", BindingFlags.Public)
mi.SetValue(MySqlDataAdapterClass, t3, Nothing) <-- ERROR
I've also tried (in substitution to the last line):
Dim mi As PropertyInfo = t2.GetProperty("SelectCommand", BindingFlags.Public)
mi.SetValue(MySqlDataAdapterClass, MySqlConnectionClass, Nothing) <-- ERROR
Many Thanks !
Gian Paolo
|
|
|
|
|
Well, neither of the two lines you tried would appear to do what you want.
Gian Paolo WNA wrote: mi.SetValue(MySqlDataAdapterClass, t3, Nothing)
This attempts to make a call that would look like this normally:
MySqlDataAdapterClass.SelectCommand = t3 t3 is a Type object, but the property is looking for a MySqlCommand object.
Gian Paolo WNA wrote: mi.SetValue(MySqlDataAdapterClass, MySqlConnectionClass, Nothing) <-- ERROR
That attempt would look like this normally:
MySqlDataAdapterClass.SelectCommand = MySqlConnectionClass Again, this is the wrong object type. The SelectCommand property is looking for a MySqlCommand object, but you supplied a MySqlConnection object.
You might wish to try this:
mi.SetValue(MySqlDataAdapterClass, MySqlCommandClass, Nothing)
|
|
|
|
|
Hey guys, Could someone give me a list of all the SQL Server 200 updates? I just want the names of each and every ittby bitty one and not the download links! Thanks in advance.
|
|
|
|
|
|
For publicly available releases, all you really need is SQL Server 2000 Service Pack 4. There have been no security patches since then. If you want to search for security bulletins for a specific product, try here[^].
Future updates for SQL Server 2000 will be available on Microsoft Update. Go to http://update.microsoft.com/microsoftupdate/[^] to get started. If you have Windows Server Update Services, updates for SQL Server 2000 will be on there.
If you're experiencing a specific problem, contact Support.
|
|
|
|
|
Can I add or remove column in datagrid at runtime
neeraj
|
|
|
|
|
Hi everybody
I am a beginner and facing the problem in calling a Stored Procedure from within my VB.NET 2005, as below:
MY Stored Procedure goes like;
ALTER PROCEDURE ByRoyalty @percentage int, @avgprice float Output<br />
AS<br />
SELECT @avgprice= AVG(price) FROM titles<br />
SELECT au_id FROM titleauthor<br />
WHERE titleauthor.royaltyper = @percentage<br />
DECLARE @numtitles Int<br />
SELECT @numtitles=COUNT(*) FROM titles<br />
RETURN @numtitles
My VB code is as below:
Dim cmd As New SqlCommand("ByRoyalty", Conxn)<br />
With cmd<br />
.CommandType = CommandType.StoredProcedure<br />
<br />
.Parameters.Add("@numtitles", SqlDbType.Int)<br />
.Parameters(0).Direction = ParameterDirection.ReturnValue<br />
<br />
.Parameters.AddWithValue("@percentage", 100)<br />
.Parameters(1).Direction = ParameterDirection.Input<br />
<br />
.Parameters.Add("@avgprice", SqlDbType.Float)<br />
.Parameters(2).Direction = ParameterDirection.Output<br />
End With<br />
Dim dr As SqlDataReader = cmd.ExecuteReader()
Running the above vb code reports the following error:
"Procedure or function ByRoyalty has too many arguments specified."
Please help
-- modified at 8:06 Friday 11th August, 2006
|
|
|
|
|
numtitles needs to be an input to the procedure:
Try:
<br />
ALTER PROCEDURE ByRoyalty @percentage int, @avgprice float Output, @numtitles int Output<br />
AS<br />
SELECT @avgprice= AVG(price) FROM titles<br />
SELECT au_id FROM titleauthor<br />
WHERE titleauthor.royaltyper = @percentage<br />
SELECT @numtitles=COUNT(*) FROM titles<br />
RETURN @numtitles<br />
Mike Lasseter
|
|
|
|
|
Sorry, it still reports the same error. Any other idea, please!
|
|
|
|
|
Hi Friend,
Can you change the line as follows.
.Parameters.Add("@percentage", 100)
- I think 'Add' Method is enough here.
With Regards,
Pandian S
|
|
|
|
|
THOUSANDS OF PARDONS to all the friends who tried to help. The problem was something different.
As a matter of fact, all the changes I was making had been commencing in the LOCAL COPY of my database. For this reason, my changes did not reflect in the result set.
I again aplogize everybody.
With gread regards.
|
|
|
|
|
sqlmanager.exe - Application Error
The instruction at "0x780104ac" referenced memory at "0x009e00af".The memory could not be "read".
|
|
|
|
|
You're best reporting that to Microsoft.
|
|
|
|
|
hi there,
I've got a table with
ID int [primary key]
TypeID int
PATH varchar(25)
now I'd like to do something like "select the ID of a random record with TYPEID = 1".
is this possible in TSQL? If so, can somebody drop a hint?
thanks in advance!
/matthias
I love deadlines. I like the whooshing sound they make as they fly by.
[Douglas Adams]
|
|
|
|
|
|
Is school back already ??? Oh well there goes summer.
Look where you want to go not where you don't want to crash.
Bikers Bible
|
|
|
|
|
Well I am trying to make an admin section to allow my other admins of my site able to add content to my mysql database without giving them phpmyadmin access and without teaching them out to use it as well. So I am trying to make a form that they can use to fill in a few simple fields and then it create the tables in the database and then insert a row in a seperate table that is already made.
Here is how I want it to work...
Name:
Filename:
Category:
Header Image:
"Name" would be used for the print output saying that "NameHere has been added to the database" and also be used in inserting a value in a table that has already been created called "pageheaders".
The Filename will be used many times...this will be the from portion of the names of the tables as well as part of the insert into pageheaders.
Category will just be part of the insert into pageheaders.
Header Image is also just part of the insert.
Here is the form portion of what I am trying to do...the action is calling to another page where the sql stuff is because that is the only way I knew to do it but if you know a better way to have them in the same file then I am more than happy to use that.
Form Code:
<form action="tablesandinsert.php" method="post"><br />
Name: <input type="text" name="name"><br><br />
Filename: <input type="text" name="filename"><br><br />
Category: <input type="text" name="category"><br><br />
Header Image: <input type="text" name="headerimage"><br><br />
<input type="submit" value="Submit"><br />
</form>
And here is the sql code that is used for inserting and creating sql stuff...it doesnt actually insert anything or create the tables so I obviously did something wrong.
SQL Stuff:
$name=$_POST['name'];<br />
$filename=$_POST['filename'];<br />
$category=$_POST['category'];<br />
$headerimage=$_POST['headerimage'];<br />
<br />
$query="CREATE TABLE `$filename_fins` (<br />
`gif_id` mediumint(9) NOT NULL auto_increment,<br />
`fingifurl` text NOT NULL,<br />
PRIMARY KEY (`gif_id`)<br />
) ENGINE=MyISAM DEFAULT CHARSET=latin1;<br />
<br />
CREATE TABLE `$filename_trons` (<br />
`gif_id` mediumint(9) NOT NULL auto_increment,<br />
`trongifurl` text NOT NULL,<br />
PRIMARY KEY (`gif_id`)<br />
) ENGINE=MyISAM DEFAULT CHARSET=latin1;<br />
<br />
CREATE TABLE `$filename_misc` (<br />
`gif_id` mediumint(9) NOT NULL auto_increment,<br />
`miscgifurl` text NOT NULL,<br />
PRIMARY KEY (`gif_id`)<br />
) ENGINE=MyISAM DEFAULT CHARSET=latin1;<br />
<br />
INSERT INTO `pageheaders` VALUES ('$name', '$filename', '$headerimage', '$category/$filename/index');";<br />
$result=mysql_query($query);<br />
Print "$name has been successfully added to the database.";<br />
?>
so any help on where I went wrong?
|
|
|
|
|
Hi,
I am trying to use C# to execute the following procedure.
call RESOURCE_DEVELOPMENT.PHILIPS_REPORTS.ConfirmUDFExists('COM_X');
The error is:
ORA-12154: TNS:could not resolve service name
This is the c# code that I am using.
please note that the above procedure works fine in oracle.
objConn = DatabaseConnection.GetConnection(objContext);
objConn.Open();
objCmd = new OracleCommand(strSQL, objConn);
objCmd.CommandText = strSQL;
objCmd.CommandType = CommandType.Text;
objCmd.ExecuteNonQuery();
|
|
|
|
|
You do not show anywhere how the variable 'objContext' was instantiated or initialized. There probably needs to be some database name, user name and user password in that variable.
Chris Meech
I am Canadian. [heard in a local bar]
Nobody likes jerks. [espeir]
|
|
|
|
|
You will have to check your "tnsnames.ora" file contains an entry for the database you are trying to connect to.
A few more details would help though.
|
|
|
|
|
hi all,
We are requesting for data from SQL Server which is in a server(it is in London).The requested stored Procedure has TWO DateTime Variables.(@startdate DATETIME,@enddate DATETIME)
So when we doing request with StartDate='23/09/2006' AND EndDate='29/09/2006' , startdate is converted to '24/09/2006' and enddate is converted to '30/09/2006'. Then request result is completed wrong.
Can anyone please tell me why it happens?
I do not change datetime when processing.It is happen automatically.
thanks in advance.
|
|
|
|
|
select getutcdate()
select getdate()
|
|
|
|
|
i create application by using vb.net2005 i add sqldataadapter to my project when i try to configure dataadapter to connect to database this error apear
*************************
an error has occurred while establishing a connection to the server.when connecting to sql server 2005 this failure may be caused by the fact that under the default setting sql server does not allow remote connection (provider:sql network interfaces,error:26-error location server/instance specificed)
**************************
i need to solve this error to end my project
plz answer me very quickly
thanks
ma_refay
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
