how can I get this to work in VB
Filterinfo = "%123%" 'match 123
Data1.RecordSource = "select * from [Customer] where [AccountNo] like '" & filterInfo & "'"
http://www.experts-exchange.com/Programming/Languages/Visual_Basic/Q_10053849.html
Zones:
Visual BasicDate Answered: 05/27/1998 Grade: C Views: 0
I am trying to schedule a copy task with windows task scheduler. The problem is, the scheduler wants me to assign a .exe file to be run as the task. I tried looking for the copy command on my sys...
http://www.experts-exchange.com/OS/Microsoft_Operating_Systems/Windows/Win95_3x/95/Q_10676...
Zones:
Windows 95Date Answered: 07/12/2000 Grade: A Views: 0
Hi
My code below is not working.
Example,
<cfquery name="Get_Pending" datasource ="CD_Music" dbtype="ODBC">
Select * from Sales_Order
Where Delivery_Flag<> "Y"
</cfquery> ...
http://www.experts-exchange.com/Software/Server_Software/Web_Servers/ColdFusion/Q_11339077...
Hi all,
I'm facing a very strange problem, I issue the following query on Oracle8i on NT server:
SELECT *
from jobs
where expire_date = TO_DATE('16 10 2000', 'DD MM YYYY');
OR
SELECT *
...
http://www.experts-exchange.com/Database/Oracle/Q_11494180.html
Zones:
OracleDate Answered: 10/09/2000 Grade: A Views: 0
Hi,
I writing a program with database and try to filter some records like -->
Private sub cmdfilter_click()
data1.RecordSource="SELECT * FROM tblemp where='" & trim (text2.text) & "'"
db...
http://www.experts-exchange.com/Programming/Languages/Visual_Basic/Q_20128267.html
Zones:
Visual BasicDate Answered: 06/01/2001 Grade: A Views: 0
I met a problem that I can not login in my win2000 system which said "the local policy of this system does not permit you to log on interactively". Friends told me that I need ntrights to connect t...
http://www.experts-exchange.com/OS/Microsoft_Operating_Systems/Windows/2000/Q_20244814.htm...
Zones:
Windows 2000Date Answered: 06/02/2003 Grade: B Views: 0
hi
i'm having a slight problem with a stored procedure on sql server 2000.
I'm writing a simple stored procedure that will return delivery consignments that haven't been manifested and at the...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_20398409.html
I would like to run a loop in an ASP Page (preferably using ADO and SQL to connect to the db) that detects all the table and column names in an ACCESS database.
I think I can do this with somethin...
http://www.experts-exchange.com/Web_Development/Web_Languages-Standards/ASP/Q_20403244.htm...
Zones:
ASPDate Answered: 08/02/2003 Grade: B Views: 0
I need to write a select statement that selects from a range of dates. I have been able to get this to work. What I have done so far is:
Select * From table_a Where (date1 > 'xxxx-xx-xx') And (d...
http://www.experts-exchange.com/Microsoft/Applications/FoxPro/Q_20415633.html
Zones:
FoxProDate Answered: 08/10/2004 Grade: A Views: 0
I am new to Oracle and I have quick question.
I am passing a few optional parameter into a stored procedure. I need to conditionally select data based on the parameters being passed. So in the...
http://www.experts-exchange.com/Database/Oracle/Q_20427368.html
Zones:
OracleDate Answered: 12/16/2002 Grade: A Views: 0
