473,385 Members | 1,661 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,385 software developers and data experts.

ASP file in InterDev can't "Start" as VBP file in VisualBasic?

so how I can test asp code as I test VB project?
the function such as "start","step into",etc. all can't use when I
edit asp file, InterDev can't "Start" asp file?
the IE give me such a simple error report:
error type:
Microsoft VBScript ÔËÐÐʱ´íÎó (0x800A01C2)
/FindMerchant/search.asp,Line19
the line 19 is: rsResult=search(strKeyword)

<%
Set conn = Server.CreateObject("ADODB.Connection")
conn.open strPath
dim rsResult
set rsResult = Server.Createobject("ADODB.recordset")

rsResult=search(strKeyword)
%>
<%
Function Search(keyword) 'keywordÀïµÄ¹Ø¼ü×ÖÓÿոñ·Ö¿ª

Dim sqlQuest
Dim keywordGroup
dim rs
set rs= server.createobject("ADODB.Recordset")
keywordGroup = Split(keyword)
'°ÑkeywordÀïµÄ¹Ø¼ü×ÖÒÔ¿Õ¸ñ×ö·Ö¸î·û×°µ½Êý×éÀï,
keyword = "" '×¼±¸ÓÃÀ´×°¾*´¦ÀíºóµÄkeyword
Dim i

For i = 0 To UBound(keywordGroup)
'¸øÿ¸ö¹Ø¼ü×Ö¼ÓÉÏÌØÊâ·ûºÅÐγÉSQLÓï·¨
keywordGroup(i) = "'%" & keywordGroup(i) & "%'"
Next

For i = 0 To UBound(keywordGroup) '×éºÏ¾*´¦ÀíºóµÄ¹Ø¼ü×Ö
If keyword = "" Then
keyword = keywordGroup(i)
Else
keyword = keywordGroup(i) & "and" & keyword
End If
Next

sqlQuest = "Select Tel,Address From tableMerchant Where
Commodity LIKE " & keyword
rs.Open sqlQuest, conn
Dim a
Do While Not rs.EOF
a = a & rs.Fields.Item("Tel") & rs.Fields.Item("Address") &
";"
rs.MoveNext
Loop
rs.Close
Search =rs
conn.Close

End Function
%>

I'm sorry my english is so poor,
so forgive me if my word had make you uncomfortable.
I'll try my best to express my question correctly
Jul 19 '05 #1
0 1321

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
by: Hal Vaughan | last post by:
I know that I need to launch a VBS file on Windows this way: Win9x: Runtime.getRuntime().exec("start script.vbs"); WinNT: Runtime.getRuntime().exec("cmd /c start script.vbs"); I'm doing...
0
by: Bill Davy | last post by:
I am building a C++ program (main.exe) with VC6 which expects to call the Python DLL. When I start it (under the debugger), I get: "This application has failed to start because python24_d.dll was...
2
by: Greg Smith | last post by:
I am trying to use the "Ping" command and capture the output. I can run it with the following: System.Diagnostics.Process.Start("ping.exe","-a 123.123.123.123"); This works fine. However,...
4
by: choihead | last post by:
Hi All, How can i excuete a bat file by c#? I used System.Diagnostics.Process.Start("../stage.bat"); but it cannot find the file, is this the correct method to call the bat file? thx...
3
by: Dean Slindee | last post by:
The code below is being used to launch WinWord.exe from a VB.NET program. Word launches, but displays this error message: "Word has experienced an error trying to open the file. Try these...
2
by: Dean Slindee | last post by:
The code below is being used to launch WinWord.exe from a VB.NET program. Word launches, but displays this error message: "Word has experienced an error trying to open the file. Try these...
2
by: webmastermuztagh | last post by:
Hi! I know something about HTML and no more but recently i really like to learn ASP but unfortunatly no body know ASP here. So is there any body can help! How can start asp and what should i know...
4
by: =?utf-8?B?Qm9yaXMgRHXFoWVr?= | last post by:
Hello, what is the use-case of parameter "start" in string's "endswith" method? Consider the following minimal example: a = "testing" suffix="ing" a.endswith(suffix, 2) Significance of...
1
by: acmdo | last post by:
Hello, The following question is about the name of file, with commas and periods, using VB.net 2005 when I try to use the process.start instruction I can open a file in explorer with...
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...
0
by: ryjfgjl | last post by:
In our work, we often need to import Excel data into databases (such as MySQL, SQL Server, Oracle) for data analysis and processing. Usually, we use database tools like Navicat or the Excel import...
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.