Web Development

Multiple recordsets with VB-ASP-SQL Server 2000

13-Apr-04 15:42

I tend to agree with Lauren. Make something like this:

<form method="POST" action="thispage.asp">
  <table border="0" cellpadding="2" cellspacing="0">
    <tr>
      <td>Tape Name</td>
      <td>Type</td>
      <td>System</td>
    </tr>
    <tr>
      <td>
        <p><input type="text" name="T1" size="20"></p>
      </td>
      <td><select size="1" name="D1">
          <option value="1">Type 1</option>
          <option value="2">Type 2</option>
          <option value="3">Type 3</option>
        </select></td>
      <td><select size="1" name="D4">
          <option value="1">System 1</option>
          <option value="2">System 2</option>
          <option value="3">System 3</option>
        </select></td>
    </tr>
    <tr>
      <td><input type="text" name="T2" size="20"></td>
      <td><select size="1" name="D7">
          <option value="1">Type 1</option>
          <option value="2">Type 2</option>
          <option value="3">Type 3</option>
        </select></td>
      <td><select size="1" name="D9">
          <option value="1">System 1</option>
          <option value="2">System 2</option>
          <option value="3">System 3</option>
        </select></td>
    </tr>
    <tr>
      <td><input type="text" name="T3" size="20"></td>
      <td><select size="1" name="D8">
          <option value="1">Type 1</option>
          <option value="2">Type 2</option>
          <option value="3">Type 3</option>
        </select></td>
      <td><select size="1" name="D10">
          <option value="1">System 1</option>
          <option value="2">System 2</option>
          <option value="3">System 3</option>
        </select></td>
    </tr>
  </table>
  <p><input type="submit" value="Submit" name="B1"></p>
</form>

Then, when you post, check each of the textboxes and each of the drop down lists to determine if a value was entered or not.

Yes, you could also use a checkbox that asks "enter more values" but that could get repetitive for the person using the app.

What a piece of work is man, how noble in reason, how infinite in faculties, in form and moving how express and admirable . . . and yet to me, what is this quintessence of dust? -- Hamlet, Act II, Scene ii.

Hitu8-Apr-04 7:14

Hitu

8-Apr-04 7:14

Hi,

I am using ASP, VB & SQL Server in my application. I have written an Stored Procedure which containts multiple SELECT statements (returns multiple recordsets),
which in turn is returned to VB (middle tier). The connection to the database is established using ODBC layer. The recordset returned to VB from SQL is then returned to ASP. If I try to use NextRecordSet method of the returned recordset it gives me the error:

Current provider does not support returning multiple recordsets from a single execution.

If I directly connect to the Stored Procedure from ASP & then use NextRecordSet method & it works. Also, if I use NextRecordset method in VB after returning multiple recordsets from Stored Procedure then it works.

But it does not work when ASP calls VB which in turn calls Stored Procedure.

Please help.

Thanks
Hitesh

Re: Multiple recordsets with VB-ASP-SQL Server 2000

John Kuhn9-Apr-04 17:24

How to put a Search Engine on a website

9-Apr-04 17:24

Without trying it out for myself, it seems like the problem could be that your VB object is returning a static, in-memory recordset, and not a reference to a dynamic recordset. It isn't clear to me that it is possible to return a dynamic recordset along with the ability perform subsequent method calls -- since that implies that the connection state is still open, that the VB object persists everything correctly, etc., especially since, in most cases, people do things like:

Set rs = vbObject.GetRecordSet(para1, para2)

Perhaps, the alternative would be:

vbObject.StartRecordSet para1, para2
Do While Not vbObject.RecordSet.EOF
 ...
Loop
vbObject.GetNextRecordSet
Do While Not vbObject.RecordSet.EOF
 ...
Loop

and then the implementation of the recordset is internal to the object?

What a piece of work is man, how noble in reason, how infinite in faculties, in form and moving how express and admirable . . . and yet to me, what is this quintessence of dust? -- Hamlet, Act II, Scene ii.

srt78-Apr-04 6:08

srt7

8-Apr-04 6:08

hello all,

Can anyone suggest good articles/tutorials etc. for this?

I need to put in a search engine for our organization which will search only within the pages of the organization's domain.

Can I use Google for this?

Regards,
Tiruvan

The no answer board....I guess

srt79-Apr-04 3:55

srt7

9-Apr-04 3:55

I guess this forum is only for questions....not answers Smile | :)

Regards,
Tiruvan

Re: How to put a Search Engine on a website

John Kuhn9-Apr-04 16:25

problem in debugging ISAPI dll.

9-Apr-04 16:25

Well, perhaps you should have started with Google! The answer is "yes" you can use an existing search engine for searching your domain, if your domain is open to the public. Google has information about how to do this on its site, under services or some such thing.

If you are interested in implementing your own search engine, you can try to implement index services under IIS, or you could buy an appliance that hosts the search function and "plugs in" to your site.

What a piece of work is man, how noble in reason, how infinite in faculties, in form and moving how express and admirable . . . and yet to me, what is this quintessence of dust? -- Hamlet, Act II, Scene ii.

suvarna joshi8-Apr-04 2:16

suvarna joshi

8-Apr-04 2:16

I have one ISAPI dll developed in Delphi 5.0. I want to debug that dll. For that matter I am running the service interactively that means as a process. To do this i have done all the setings like,
Adding domain user to local policies User rights- Act as a part of operaing system, Generate Security audits. Log on locally etc.
Also i have stopped the service W3svc, ftp, smtp and iisadmin and have made thier mode manual. I was able to make the inetinfo as a process. Then i have set the run parametrs of my application as -e W3Svc and i am running inetinfo.exe. But while degugging inetinfo starts, but it fails to start w3svc service and gives error - "The server was unable to logon the Windows NT account 'IUSR_PUN033' due to the following
error: A required privilege is not held by the client. The data is the error code.
For additional information specific to this message please visit the Microsoft Online
Support site located at: http://www.microsoft.com/contentredirect.asp. "

I am using OS - Win 2000 and IIS 5.0. can anybody help me in this. I don't know where I am going wrong.

Need CAB-file tutorial… and ActiveX-help

anderslundsgard7-Apr-04 5:02

anderslundsgard

7-Apr-04 5:02

Can’t get help how to make a client of my website download and run my ActiveX. I’ve created .inf (and an .ocx) files and created a .cab-file but the installation and registration doesn’t seems to work properly. I get the ”Unknown” status on an ActiveX in the Downloaded Program Files in my WINdir.

When I go into ”http://localhost/ WebSIMx/S/SIMx.html” it I get the prompt -> Yes, but the screen becomes empty.

My SIMx.html look like this:

<object id="SIMx" width="800" height="600
" classid="CLSID:8430C4BC-8DC1-4987-95AB-9ED7913CA4EC"
="" codebase="http://localhost/WebSIMx/S/SIMx.CAB#version=1,0,0,2">

I have ALL settings ”Enable” in my Internet Explorer.
How can I check there is no version-error?

Very pleased for help - APe

.....and justice for all

APe

ASP FILE NOT CORRECT

Brendan Vogt6-Apr-04 21:23

Brendan Vogt

6-Apr-04 21:23

My previous posting did not come out correctly. But you should be able to make out what is going on there...

Brendan

CLIENT-SIDED VALIDATION NEEDED

Brendan Vogt6-Apr-04 21:21

Brendan Vogt

6-Apr-04 21:21

I need an image file to be validated, before it get uploaded. It must just check if the file is greater than a certain size, and that it is JPEG. I do this using the FSO. Is this the best way to do it, and if so, am I doing it correctly. Attached is a section of my javascript function which is in my global.js file and my ASP file where a user can select an image.

JAVASCRIPT FUNCTION:
function checkFileDimensions(intFileSize) {

var objFSO = new ActiveXObject("Scripting.FileSystemObject");
var strPath = document.frmImageUpload.txtFile.value;
var strFileType = "JPEG Image"
var objFile = objFSO.GetFile(strPath);

/* Validate file dimensions */
if (objFile.Type != strFileType) {
alert("Invalid File Type - Please re-save your image in JPEG format.");
return false;
}
else if (objFile.Size > intFileSize) {
alert("Invalid File Size - Please re-save your image to less that 10 KB.");
return false;
}
else
return true;

}

ASP FILE:
<%@ LANGUAGE=VBScript %>

<title>Agent Image Upload

Agent Image Upload

Select an image to upload.

NOTE: the following specifications apply:

1. File type: must be JPEG

2. File size: not bigger that 10 KB

3. Image width in pixles: 90

4. Max image height in pixles: 120

If you are not sure how to format your images, please contact us
on (021) 790-6216

If you cancel this operation, please remember to un-check the
tick box on the agent page.

I hope someone can help. Thanks
BRENDAN

Re: CLIENT-SIDED VALIDATION NEEDED

alex.barylski9-Apr-04 19:07

alex.barylski

9-Apr-04 19:07

Client side validation is easy to get around.

Also Doesn't FSO require end users to click a 'Always trust Microsoft' check box if they haven't already???

I'd check it on the server side of things...

Cheers Smile | :)

How do I print my voice mail?

Viewing uploaded file from SQL Server

vj_asu6-Apr-04 6:25

vj_asu

6-Apr-04 6:25

Hi All,

I am able to upload the files to the SQL Server 2000 using SA FileUp Component. Now I would like to view the uploaded file from the client machine and also I want to provide the users to save that uploaded file in their local machine. I had tried the following piece of code to do that, but no luck so far. It is writing the content in browser window with some invalid characters except for the text file. Could any of you please help me with this?

Dim MSCS, Rs, strSQL
Set MSCS= Server.CreateObject("ADODB.Connection")
MSCS.ConnectionTimeout = 90
MSCS.Open "Provider=SQLOLEDB;data Source=server_name;Initial Catalog=db_name;User Id=user_id;Password=pwd"
Set Rs = Server.CreateObject ("ADODB.Recordset")
'strSQL = "SELECT * FROM tbl_test_upload WHERE file_id = " & request("id")
Rs.Open strSQL, MSCS, 2, 3
Response.ContentType = Rs("file_type")
Response.AddHeader "Content-Disposition", "filename=" & Rs("file_name")
Response.BinaryWrite Rs("file_data")
Rs.close

Thanks.

vijay

Re: Viewing uploaded file from SQL Server

Hesham Amin6-Apr-04 21:29

Hesham Amin

6-Apr-04 21:29

you also need to change the content type to image/bmp or whatever extension.
I think you'll find a complete code for this in the asp articles in CP.

html text wrapping

harinath5-Apr-04 19:37

5-Apr-04 19:37

html text wrapping
Hi all.
here is one specific problem that my project is facing.
where there is a big text that is to be displayed.

i just wanted to wrap the data.
i am not able wrap the data, giving size for table and td tag etc.

any suggestions please..

0

<title> New Document

thisissampletextwhichiwanttolimittomultiplerowsbut
iamnotableto

Harinath
Cybernet software systems pvt. ltd.
3, Bishop wallers avenue east,
mylapore
chennai
India-600004

Roger Wright5-Apr-04 19:52

Roger Wright

5-Apr-04 19:52

Have you tried adding a <BR> tag where you want the line to break? If you want it to appear multilined, but centered, you can also add align=center to the <TD> tags.

I've felt much better since I gave up hope.

harinath5-Apr-04 20:04

5-Apr-04 20:04

no actually i am reading the data from DB.
is it not possible through html?
else i have to introduce spaces or
in the middle in my session bean while setting the data.

this is a common issue i am having. this is present in multiple places. and not all the fields take this much size.

thats y i was in confusion. if there is no way in html, then i will introduce spaces or br tag in the middle

superwinsock7-Apr-04 20:08

superwinsock

7-Apr-04 20:08

Hey

There is an html tag: <TEXTAREA WRAP=OFF|HARD|SOFT></TEXTAREA>

Not sure if this is what u lookin for??

Anyway Later

harinath7-Apr-04 22:03

HttpRequest in Opera browser

7-Apr-04 22:03

yes, its working fine.
thank u.

Harinath
Cybernet software systems pvt. ltd.
3, Bishop wallers avenue east,
mylapore
chennai
India-600004

MurthyPL5-Apr-04 5:39

MurthyPL

5-Apr-04 5:39

I am unable to send the http request using JavaScript in Opera browser. I could not find the IE equivalent of ActiveXObject("Microsoft.XmlHttp") or XMLHttpRequest() in Netscape to create an object for sending http request in Opera browser.
I appreciate any help in this regard.

MurthyPL

Re: HttpRequest in Opera browser

John Kuhn9-Apr-04 17:41

Updating of SQL Database with JavaScript/VBScript in .NET

9-Apr-04 17:41

This is from the Opera website:

ActiveX is a Windows component technique used to run arbitrary code in other programs (such as a browser). While this is a very powerful programming technique, it is also a potential security nightmare as access is given to the operating system as well as the browser itself. Even with Microsoft's security model, a large number of Internet Explorer's security holes have been related to ActiveX. Opera does not support ActiveX and consequently avoids these problems. It does support Netscape type plug-ins (NP4). This is a much smaller, but not entirely negligible security risk. While the data a Netscape plug-in can access from Opera is strictly limited, it is still a full-fledged program and can as such interact with your system. Any restrictions you may have for downloading or installing other programs should therefore apply to plug-ins as well.

Also, XMLHttpRequest is a Netscape/Mozilla specific extension to JavaScript. It seems that Opera only supports ECMA standard.

What a piece of work is man, how noble in reason, how infinite in faculties, in form and moving how express and admirable . . . and yet to me, what is this quintessence of dust? -- Hamlet, Act II, Scene ii.

ebirien4-Apr-04 23:15

ebirien

4-Apr-04 23:15

Using C#.NET I pick the access time of a user from an SQL database when he logs in. If the user uses up his access time the database needs to be updated without clicking any button, but I'm not able to call the fucntion done with C# in the codebehind from JavaScript used to implement count-down timer. Can someone help me? If it's not possible to call the function in the codebehind how can I write the same function in JavaScript or VBScript? Many thanks.

Ebi

Emailing a Form and Post Data to Access

eyespike14-Apr-04 4:27

eyespike1

4-Apr-04 4:27

I would like to post data into an Access DB from a form that is in an Email message...

Is it possible to do this? If so what would the connection string be?

I use connection strings like this for most of connections that are done locally on the server itself...

connString = "Provider=Microsoft.Jet.OLEDB.4.0;Data source=C:\inetpub\wwwroot\store.mdb;"

so for a remote post into the db would this work?

connString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=http://www.SomeDomainName.com/images/store.mdb;"

Any help would be greatly appreciated.

Seth

Temp Internet Files

3-Apr-04 7:29

Hi, just wanting to try n put together a little script for dealing with temporary internet files. My question is, is there a way to modify the index.dat file via vbscript?

Re: Temp Internet Files

hxxbin6-Apr-04 4:42

hxxbin

6-Apr-04 4:42

Sounds strange, but I don't think you can access to the index.dat file from the user, without alert the system. The unique access via vbscript, it's with FileSystem Object, and it's denied from a Internet page.

----
hxxbin

unwanted javascript behavior

harinath3-Apr-04 3:34