Hi
No need to specify a single quote in the filter.
Just specify a double quote(""-twice) , it will work fine.
ie
rs.filter="Description = ""BPD LUCKNOW(260)"" and TERRITORYNAME=""M'UNGR,B'NORE,I(602)"""
Balajee
Hi,
I need to transfer data from MsAccess to SQL Server using Visual Basic Programming (DTS References).
I came across many samples which showed transformation only between two sql server databases.
Can anyone help me.
Thanks in advance,
BALAJEE
Hi,
I need to transfer data from MsAccess to SQL Server using Visual Basic Programming (DTS References).
I came across many samples which showed transformation only between two sql server databases.
Can any help me.
Thanks in advance,
BALAJEE
Hi,
I created a new User Defined Data type in my database.
In one of my StoredProcedures , I created a temporary table and used that data type for one of the fields.
On executing the stored procedure , it says cannot find that data type.
Can't user defined data types be used in temporary...
Hi,
There is no such function in VBScript.
We have to write our own function.
Here is a sample.
<%
Function rest(xValue,xDivisor)
Dim modvalue
modvalue = xValue mod xDivisor
rest = modvalue % xDivisor
End Function
%>
Regards,
balajees
Hi,
Clicking on the reset button , the values of all the elements in the form will be set to the value which was at the time of page loading.
We wont be able to change the function of reset button.
Instead we can write our own reset function with the help of a simpe button.
regards,
balajees
Hi
1) It is possible to run a create table query from an asp page.
ex:
<%
Connection.Execute "create table student(no int,name varchar(10))"
%>
2) We can query and database object from as ASP page.
Regards,
balajees
Hi
You can refer the iframe using
self.frames['nameoftheiframe']
ex:
<iframe name=DataFrame src='data.asp' >
</iframe>
you can refer the contents of the iframe as
self.frames['DataFrame'].document.form1.text1.value
balajees
Hi Haijun,
you can use the following code for your problem
<form name=SampleForm action='sample.asp' method=post>
<input type=text name=EmpName value='<%=Request.Form("EmpName")%>'>
<input type=text name=EmpAge value='=Request.Form("EmpAge")'>
<input type=text...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.