Web Development

1-Jul-02 4:03

For your project type, select "ASP.NET Web Application". You can then type in the URL of your web server right in the same dialog.

Bonus! Like Interdev, VS.NET tries to use FrontPage server extensions for authoring. In addition it can now manage web sites over the file system. You can use drive letters or even UNC (\\) paths.

AddNew problem...

Tesic Goran28-Jun-02 15:24

Tesic Goran

28-Jun-02 15:24

Hello,

I get next error message while I try to add new record to my Access database:

Error Type:
Microsoft JET Database Engine (0x80040E09)
Cannot update. Database or object is read-only.
/Project6/AddUserToDB.asp, line 44

My critical code is:

' Create and establish data connection
Set DataConn = Server.CreateObject("ADODB.Connection")
DataConn.ConnectionTimeout = 15
DataConn.CommandTimeout = 30

'Our SQL Server code - use above line to use sample on your server
DataConn.Open strConnect

Set rsUsers = Server.CreateObject("ADODB.Recordset")
Response.Write "ADODB.Recordset is created..."

With rsUsers
.Open "Users", DataConn, adOpenDynamic, adLockOptimistic, adCmdTableDirect
.AddNew
.Fields("FirstName") = arrayTest(0)
.Fields("LastName") = arrayTest(1)
.Fields("Address") = arrayTest(2)
.Fields("Telephone") = arrayTest(3)
.Fields("EMail") = arrayTest(4)
.Fields("UserName") = arrayTest(5)
.Fields("Password") = arrayTest(6)
.Update
End With

This code works fine on MS SQL Server 7.0...

Please, help me...

Thank you in advance,

Tesic Goran

Re: AddNew problem...

Chris Rickard28-Jun-02 15:47

I need a little help with JavaScript...

28-Jun-02 15:47

Assuming you've checked File and DB permissions try changing your statement to using a SQL command instead, some thing like "SELECT * FROM Users WHERE ID=0" and leave off the adCmdTableDirect paramater.

Its possible that the JET provider only supports Read-Only cursors when used with TableDirect command type whereas the more powereful SQLOLEDB provider is able to hande it.

EZEvents ver 1.1

NickJ28-Jun-02 4:26

NickJ

28-Jun-02 4:26

In EZEvents Ver 1.1 when a person adds an entry across more than 1 month, the Summary option picks it up in the current month but not in the following month(s). It appears that it only looks at the DateVal field and not concerned with the DateVal2 field. Do you have an update to this so when i span dates (eg. June 28 to July 2) when I go to the July calendar I will see this entry in the July Summary option?

strSQL = "SELECT * FROM calendar WHERE DateVal >= " & CDbl(dMonthStartDate) & " AND DateVal <= " & CDbl(dMonthEndDate) & " ORDER BY DateVal"

Nick Jacobini

split-etm-28-Jun-02 1:43

split-etm-

28-Jun-02 1:43

The Situation:

When adding a new product, the client must be able to select which package(s) he wants it to belong to. I want to use 2 listboxes(if possible) to do this. I use one listbox to list the available options(list1) and the other to display the options the user has just selected(list2).
The problem I am experiencing though is that it seems I can only add as many packages to list2 as list2 has "<option></option>" coded into it beforehand...

The HTML code:

<tr>
<td>
<select name=list2 size=8>
<option></option> <%'*** this will allow me to add only 1 option%>
</select>
</td>
<td>
<input type=button name=AddToPackage value="<<" onclick="addSelection()">
<input type=button name=RemFromPackage value=">>" onclick="remSelection()">
</td>
<td>
<select name=list1 size=8 multiple>
<%
'***here i load entries using a recorset
%>
</select>
</td>
</tr>
</table>
</td>
</tr>

The JavaScript I am using:

function addSelection()
{
frm = document.frmAddProduct;

for(var x = 0; x < frm.list1.length; x++)
{
if(frm.list1[x].selected)
{
frm.list2[x].text = frm.list1[x].value;
}
}
}

Any help or comments on this will be GREATLY appreciated. Are there alternative ways to doing this? Is it even possible? How about using VBScript instead of JavaScript?

Re: I need a little help with JavaScript...

Chris Rickard28-Jun-02 3:57

28-Jun-02 3:57

You're limited to the length of options to the SELECT you're adding to. To increase the length use the add() method of the options collection:

function addSelection()
{
    frm = document.frmAddProduct;

    for(var x = 0; x < frm.list1.length; x++)
    {
        if(frm.list1[x].selected)
        {
            var newOption = document.createElement("option");
            frm.list2.options.add(newOption);
            newOption.text = frm.list1[x].value;
        }
    }
}

IFRAME's anyone...?

alex.barylski27-Jun-02 19:53

alex.barylski

27-Jun-02 19:53

I have encountered a problem in which IFRAMES would solve nicely, however it's to important to try and keep cross browser friendly...I really have littel experience with LAYER tag and I dunno if NS6+ even support still...???

Anyways...Whats your opinion on using FRAMES which seem to be more cross browser friendly...?

Only they are so messy...but I have the need to only refresh part of the screen/window...and getElementById() is NOT and option...

Any ideas...?

Thanx!

"An expert is someone who has made all the mistakes in his or her field" - Niels Bohr

Re: IFRAME's anyone...?

Chris Rickard28-Jun-02 4:04

Web Services and Non .NET Sites

28-Jun-02 4:04

Why is getElementById() not an option? Even if its dynamically created you can still assign it an id and store it in an array.

Of course there are other options, if its in response to an event that occurs inside the IFRAME you know what element generated the event. Also if you know its position relative to another known element you could traverse the DOM to get to it:

var anonIFrame = document.getElementById("parentElementWithKnownId").childElements[3].childElements[0];

Re: IFRAME's anyone...?

alex.barylski28-Jun-02 12:41

alex.barylski

28-Jun-02 12:41

Hey Chris

getElementById() is not an option because of browser compatibility...I would like the code to work under as many browsers as possible...

I dunno...I might go with that approach yet, i'll have to see

Cheers! Smile | :)

"An expert is someone who has made all the mistakes in his or her field" - Niels Bohr

27-Jun-02 8:39

Is it possible to have a non .net-enabled web server or application connect to a web service and execute a function?

Life, just a little more please!

Re: Web Services and Non .NET Sites

Christopher Lord28-Jun-02 20:52

Christopher Lord

28-Jun-02 20:52

yes -- If that other web server has either a web service api, or you are willing to hack up an adapter for the return XML.

For example, you can get/post your params to the web service (with get you simply stack the params on the URL as query string values), and in response get the XML document. You can then parse the XML for the data you need.

Seeking Path Of Attack

DallasTxRob26-Jun-02 21:25

DallasTxRob

26-Jun-02 21:25

I wish to provide clients to my web sight, password protected file and form upload to my server space.

Specific detail: Car Dealership: updating inventory.

I want to take info from a form for an auto along with an image file. My ultimate goal is to automatically process this data into a database and spit out the pages I need for my web site.

If I can get just the form and image sent to my server so that I can manually process the data, I would be ecstatic.

But the developer in me wants to do the full-blown package.

I need to know what is the best language to use, JavaScript, ASP, Perl or what...

I am an avid C++ and dBase developer. I am currently learning SQL. And yes, even though I have been developing in C++ for over 8 years, I have yet to develop for in an SQL environment.
Thanks,

Rob Couch

Re: Seeking Path Of Attack

Richard Deeming27-Jun-02 0:05

Richard Deeming

27-Jun-02 0:05

ASP works fine for me! Big Grin | :-D

Have a look at www.frosts4cars.co.uk.

replace web address with text friendly text

Garth26-Jun-02 14:08

Garth

26-Jun-02 14:08

I am looking for a way of removing instances of a web address/URL from an amount of text, where the URL is in the format

<a href="http://www.something.com">Site Description</a>

and replacing/reformatting the text (for a text only newsletter) into a form like

Site Description - www.something.com

I am running WSH 5.0 - so some advanced regular expression features are out....any other ideas on how this could be achieved??

Re: replace web address with text friendly text

Richard Deeming27-Jun-02 0:15

Richard Deeming

27-Jun-02 0:15

The RegExp object was added to VBScript in version 5, and to JavaScript in version 3.
Just of the top of my head, you need something like:

<a\s[^>]*?href=['"]([^'">]*?)['"][^>]*?>(.*?)</a>

to be replaced with:

$2 [$1]

(with IgnoreCase = True, Global=True, MultiLine = False)

Whats wrong with my code? HELP!

Nnamdi Onyeyiri26-Jun-02 7:34

26-Jun-02 7:34

i have this code:-

sub goodMSG(msg)
Dim badwords
badwords =  Array("arse")
For i=0 to badwords.length

wen run on my IIS server on my ocmp, it gives the error:-

Error Type:
Microsoft VBScript runtime (0x800A01A8)
Object required: 'badwords'

having only had 3hrs experience of VB, i ave not got a clue as to why this is happening.

Green Alien | [Alien] Email: theeclypse@hotmail.com URL: http://www.onyeyiri.co.uk

"What goes up must come down. Ask any system administrator"

Jeremy Falcon26-Jun-02 8:04

Jeremy Falcon

26-Jun-02 8:04

Could you post more of the code? The following runs fine on my IIS dev server (NT4 Server)...

Sub goodMSG(msg)
    Dim badwords
    badwords = Array("arse")

    For i=0 To badwords.length
        ...
    Next
End Sub

Jeremy L. Falcon<nobr>
Homepage : Sonork = 100.16311

"But everybody darlin' sometimes bites the hand that feeds."
"Remember in this game we call life that no one said it's fair."
"Just because you're winnin' don't mean you're the lucky ones."
Song: Breakdown - Album: Use Your Illusion II - Artist: Guns N' Roses

Nnamdi Onyeyiri26-Jun-02 8:20

26-Jun-02 8:20

i have put the entire code on my website here [new window]

Green Alien | [Alien] Email: theeclypse@hotmail.com URL: http://www.onyeyiri.co.uk

"What goes up must come down. Ask any system administrator"

Jeremy Falcon26-Jun-02 8:56

Jeremy Falcon

26-Jun-02 8:56

Hehe, I forgot to change to VB mode, but I figured it out when I noticed your return statements. I take it your coming from JScript, eh?

There is not a length property for an array object like in JScript. VB instead has two functions called LBound() and UBound() to find the lower and upper index bounds of the array.

Also, get rid of your return statements. To return a value you'll need to use a function and not a subroutine because subs don't return values by design. To return a value in VBScript and VB set the name of the function to the value just as you would a variable. To leave the function early you can call exit function.

Here's a short VB version of your function...

<%@ Language=VBScript %>
<%
Function GoodMsg(msg)
	Dim badwords, temp
	badwords = Array("arse", "a***hole")

	' test the text before removing characters.
	For i=0 To UBound(badwords)
		temp = InStr(msg, badwords(i))+1
		If temp > 1 Then
			GoodMsg = False
			Exit Function
		End If	
	Next
	' if we get here all went well
	GoodMsg = True
End Function
' test the messages
Response.Write GoodMsg("Nice arse.")
Response.Write GoodMsg("Nice booty.")
%>

Nnamdi Onyeyiri26-Jun-02 9:21

26-Jun-02 9:21

yep, i did come from Javascript, actually, i originally wrote the code in PHP, then converted it to javascript, now im converting it to VB.

Green Alien | [Alien] Email: theeclypse@hotmail.com URL: http://www.onyeyiri.co.uk

"What goes up must come down. Ask any system administrator"

Nnamdi Onyeyiri26-Jun-02 9:36