Connection String in Web Services for MS Access databases - Web Development Discussion Boards

Help needed urgent VBScript - Extract specific text by identifying HTML tags before the text from .htm file and log into a text file

giftsana6-Apr-06 20:21

giftsana

6-Apr-06 20:21

I have a .htm file which has the name of drivers and associated filenames.

i cld successfully remove all html tags frm this htm file and logged all data into a log file using VBScript (Thanks! to Codeproject member Sushant who helped me).

The problem is i have to be able to search for 2 strings which appears after the occurence of following tag '-->' in the htm file, actually these 2 string are the driver name and associated file name.

here is a part of the html file which i need to search for driver name/file and log into a log file. you can see that after each occurence of --> there is a driver name e.g in the first instance the driver name is "ThinkVantage Productivity Center" and associated filename is "79uz02ww.zip" after tag

. likewise there are a lot of other driver names & associated filename in the html file which i need to extract and log to a simple .txt file with the heading Driver name Filename and below the heading the driver and corresponding file name in different lines.

Pls help! a part of the html file below:

ThinkVantage Productivity Center

79uz02ww.zip

Productivity Center Supplement for ThinkPad

79uy01ww.zip

ThinkVantage Active Protection System

79sa05ww.zip

ThinkVantage Access Connections for Win2000/WinXP

79cn06us.zip

I have been trying the entire day yesterday using RegExp but no success. if there is a sample code kindly inform me.

Awaiting a reply.

Sincerely
Giftsana

Re: Help needed urgent VBScript - Extract specific text by identifying HTML tags before the text from .htm file and log into a text file

Sushant_Mathur6-Apr-06 22:45

Sushant_Mathur

6-Apr-06 22:45

Hi Sushant again Smile | :)

You can do this easily by using match function of VBScript,see the example below:
http://www.devguru.com/Technologies/vbscript/QuickRef/match.html[^]
here what you do check match.value for--> and take all the data after that,
i know that its not as easy as i am saying but lets try.

Sushant Mathur
Bangalore,
INDIA.
http://n.domaindlx.com/fun2ssh/HOME.htm

Re: Help needed urgent VBScript - Extract specific text by identifying HTML tags before the text from .htm file and log into a text file

giftsana6-Apr-06 22:46

giftsana

6-Apr-06 22:46

Sure, let me try.

Thank you so much.

Sincerely
Giftsana
Singapore

Re: Help needed urgent VBScript - Extract specific text by identifying HTML tags before the text from .htm file and log into a text file

giftsana7-Apr-06 0:36

giftsana

7-Apr-06 0:36

Hi Sushant

Thank you very much!

I cld successfully extract only driver names and file name to the text file, with the sample that you suggested. I am relieved!

I did the foll:
Dim re
Set re = New RegExp
re.Pattern = "

record not show next record

hinahinahina6-Apr-06 19:44

hinahinahina

6-Apr-06 19:44

hi i select multiple databases from droupdown menu,e.g,if select january,the database of january open,if i select fab,then fab database open,but the table name in all databases is same,i also show 10 records par page,when i click move next,then in droup down menu,first option selected,and error shows,and next page of any months not showa,plz help me,this problem comes only when i click next aur previous record,other wise droupdown menu works.
reply me son on sweetperson65@hotmail.com
thanx
bye

honey

i cant run asp page in my localmachine

Vipin.d6-Apr-06 18:59

Vipin.d

6-Apr-06 18:59

hi all,
i ve a problem in asp page.
i cant run asp pages nin my localmachine. it show erro like 500 server error
when i typr http://localhost (default page) it also show error.
i dont know what is the pblm??
i installed IIS and dotnet it run without any pblm.
my os is winXP Prof.

All I ever wanted is what others have....

CrazySanker

-- modified at 1:00 Friday 7th April, 2006

Re: i cant run asp page in my localmachine

Guffa7-Apr-06 1:30

Guffa

7-Apr-06 1:30

Disable "Show friendly HTML error messages" in the advanced options in Internet Explorer, so that you see the complete error message from the server.

---
b { font-weight: normal; }

Connection String in Web Services for MS Access databases

gaorellana6-Apr-06 15:53

gaorellana

6-Apr-06 15:53

Hello:

I am developing a web service which is consuming data from an MS Access database. I am in trouble when testing the service from a client.

When debuging the web service directly either I define the connection stirng as 1) or 2) it works.

1) connectionString="Provider=Microsoft.Jet.OLEDB.4.0;Data Source='~\App_Data\OVRData.mdb'"
2) connectionString="Provider=Microsoft.Jet.OLEDB.4.0;Data Source='E:\Projects\MyWebService\App_Data\OVRData.mdb'"

But if I try to test the service from my client only writing the Web.config as the option 2) works. Otherwise
try to find the file in something like c:\Documents and Settings\...\VisualStudio\IDE\...

Given I have no control on which absolute path is going to have when I move to the web server. How can I write my connection string to be relative?

Thanks

Re: Connection String in Web Services for MS Access databases

Vasudevan Deepak Kumar6-Apr-06 18:25

Vasudevan Deepak Kumar

6-Apr-06 18:25

You can try using Server.MapPath to get the physical path of the application and then build the path for your MDB database.

Vasudevan Deepak Kumar
Personal Web: http://www.lavanyadeepak.tk/
I Blog At:
http://www.dotnetjunkies.com/weblog/deepak/
http://deepakvasudevan.blogspot.com/
http://deepak.blogdrive.com/

Tree view like the code project forum

2hdass6-Apr-06 9:52

2hdass

6-Apr-06 9:52

I am in a design stage for my new web applciation. What should i start looking at if i want my web application to act something like this forum, where u click on a topic it will expand the content?

thx for your suggestions!

Re: Tree view like the code project forum

alexey _N10-Apr-06 18:45

alexey _N

10-Apr-06 18:45

Try this html:

<html>
<head>
<script language="JavaScript" type="text/javascript">
function Expand(name)
{
var elem = document.getElementById(name);
if (elem.style.display == "none")
{
elem.style.display = "block";

}
else
{
elem.style.display = "none";
}
}
</script>
</head>
<body>
<Table >
<tr>
<td>
<a href="#" onclic k ="Expand('content');">click this</a>
</td>
</tr>

<tr>
<td>
<table id="content">
<tr>
<td>
line1<br/>
line2<br/>
line3
</td>
</tr>
</table>
</td>
</tr>

</body>

</html>

-- modified at 0:47 Tuesday 11th April, 2006

Re: Tree view like the code project forum

2hdass12-Apr-06 3:05

2hdass

12-Apr-06 3:05

hmmm...this doesnt seem to be working...

Re: Tree view like the code project forum

alexey _N12-Apr-06 17:31

alexey _N

12-Apr-06 17:31

Remove space in "onclick" If I post it without quotes it'll be replaced by "removed" word. Like in this:

<html>
<head>
<script language="JavaScript" type="text/javascript">
function Expand(name)
{
var elem = document.getElementById(name);
if (elem.style.display == "none")
{
elem.style.display = "block";

}
else
{
elem.style.display = "none";
}
}
</script>
</head>
<body>
<Table >
<tr>
<td>
<a href="#" onclick ="Expand('content');">click this</a>
</td>
</tr>

<tr>
<td>
<table id="content">
<tr>
<td>
line1<br/>
line2<br/>
line3
</td>
</tr>
</table>
</td>
</tr>

</body>

</html>

Re: Tree view like the code project forum

2hdass13-Apr-06 14:10

2hdass

13-Apr-06 14:10

cool.. this works, now how do i do this part in C#? whats the libary for elem.style.display? or should i make it a server control?

<script language="JavaScript" type="text/javascript"><br />
            function Expand(name)<br />
            {<br />
        var elem = document.getElementById(name);<br />
               if (elem.style.display == "none")<br />
               {<br />
                    elem.style.display = "block";<br />
                    <br />
               }<br />
               else<br />
               {<br />
                    elem.style.display = "none";<br />
               }<br />
            }<br />
        </script>

Re: Tree view like the code project forum

alexey _N13-Apr-06 17:32

alexey _N

13-Apr-06 17:32

That was a simple html solution.
Read this article http://www.codeproject.com/asp/aspforum-n-membersys.asp
for complete information.

Best regards, Alexey.

ListBox value

ekendricks6-Apr-06 6:17

ekendricks

6-Apr-06 6:17

I have a listbox "Employee" that is pouplated with a SQL stmt. In the SQL stmt, I can SELECT ID, Name, Dept, Etc. The listbox shows the "ID - 25" and "Value -Name". I do not need to see any additional information in the listbox, but I need a javascript function to populate a textbox "Dept" with the "Dept value" that was retreived with the SQL stmt.

Ernest

Re: ListBox value

cdengler6-Apr-06 8:41

cdengler

6-Apr-06 8:41

More information required here.. Are you saying that you already have the listbox populated, and that when a users selects one of the items in the dropdown that you want that item's text data to be populated in a separate text box?

Re: ListBox value

ekendricks6-Apr-06 9:07

ekendricks

6-Apr-06 9:07

Correct: This list box is already populated using a SQL stmt. User can currently select an item in the dropdown.
The fields in the list box are ID=1d, and Value=Name which is displayed to user. The SQL stmt returns: ID - Name - Dept. I need an onchange event that will populate another text box "Dept" with the 3rd column of the list box "Dept".

Thanks

Ernest

Re: ListBox value

cdengler10-Apr-06 8:47

cdengler

10-Apr-06 8:47

Ok, if I understand this, what you're saying is that you have three values... the ID, the name and the Department. And now based upon which one they select, you need to populate another area with the department value.

I would create a Javascript array on the page populated when the SQL populates the dropdown. The array would contain the IDs of each dropdown associated with DEPARTMENT. On the OnChange, have the script look up the value of the selected item in the dropdown, get the department value, and populate the other area. Make sense?

Re: ListBox value

ekendricks10-Apr-06 9:02

ekendricks

10-Apr-06 9:02

Yep... you understand..... Thanks for the reply.....
Now I just need to find samples or figure out how to do just that..

Thanks

Ernest

ISAPI DLL under WinCE Registry

RamL5-Apr-06 23:04

RamL

5-Apr-06 23:04

Hi All,

Would u tell me
what are the settings needed under WinCE Registry to work the ISAPI extension DLLS?

How to do it?

Thankx in advance,

Regards,
Ramesh.

middle web service

hung_ngole5-Apr-06 16:22

hung_ngole

5-Apr-06 16:22

Hi,
I'm writing a web service using ASP.NET in VS.NET 05, I want my web service can receive the request from client and get the response (including HTML, Javascript...) from the web server. It is in the middle of web server & client.
How can I do?
Thanks,

Hung

Re: middle web service

cdengler10-Apr-06 8:51

cdengler

10-Apr-06 8:51

Hung,

I'm guessing that no one is replying to this because it's hard to follow. Do you want your web service to simply return HTML and Javascript? What is this HTML and Javascript?

quick javascript question

Sam 20065-Apr-06 12:18

Sam 2006

5-Apr-06 12:18

hi,

i've got a quick javascript question. i don't know if its possible... how can i call a function when text in a textbox is changed?

thanks in advance,
sam kline

Re: quick javascript question

smadan5-Apr-06 21:37

smadan

5-Apr-06 21:37

Hi,

For this purpose try writing code in the textchanged event or else use an extended textbox.
Extended textboxes allow you to write delegates and events and on those events javascript functions can be called.

Code for extended text box can be found at the code project site itself.

Thanks.

Last Visit: 31-Dec-99 18:00 Last Update: 29-Apr-24 19:03

Refresh

ᐊ Prev 1...919 920 921 922923924 925 926 927 928 Next ᐅ

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.