Search results for query: *

Hey everyone! Just wanted to ask your opinion on what is a better way to execute sql statements in a loop. First version opens and closes connection inside a loop, and the other does it once outside of it. I have read that it is better to open and close connections immediately, but still...

Hey everyone! I have a weired problem with FileSystemObject. Whenever I try to create a folder or delete a file, IIS stops responding and I have to restart it. I have full permissions for the appropriate folders set up for "IUSR_machine" (anonymous user) . Here's the example of the...

Hey everyone! Just wanted to know if anyone creates JPG thumbnaisl in ASP. I am working on a project that requires creating thumbnails and I wanted to get your opinions on which 3rd party components to use. So if you create thumbnails (JPG files) on your site, I'd appreciate your advice...

On my local website (IIS 5.0 running on Windows 2000 Professional), the session is not preserved for some odd reason. I made sure the "Enable Session State" is checked under IIS configuration applet (Home Directory->Configuration->App Options). I also made sure the browser settings...

On my local website (IIS 5.0 running on Windows 2000 Professional), the session is not preserved for some odd reason. I made sure the "Enable Session State" is checked under IIS configuration applet (Home Directory->Configuration->App Options). I also made sure the browser settings...

I am creating a PDF file from within my ASP page. I downloaded Adobe FDF Toolkit, registered DLLs, configured MIME types. Now, the problem I have is that when I write a sample PDF back to the client, it is cached and when I make changes in the ASP code, the file displayed to the client is the...

Hi everyone! When I capture a movie from my DV camera using FireWire, I can only capture about 7 min of video, and then I get the message that the file size was exceeded. The size of a movie that is 7 min long is about 4GB... Is that normal? Can I capture the video with some sort of...

Hi everyone! I develop a page that has 40 checkboxes, all named the same. I do it so that when I submit it to an ASP page, the value becomes "box1val, box2val, box3val, box4val, ..." In other words, the values are added up and separated by commas. Here is what I am talking about...

Hey! On the page I am working on, I use a stored procedure to search actors resumes by gender, ethnicity, age, and keywords. Here is how my ASP code look like: resGender = String(Request.Form("resGender")); resAgeRange = String(Request.Form("resAge")); resEthnicity = (...

When I run this stored procedure: CREATE PROC testCDs @TotalRecs int OUTPUT AS SELECT cdID, cdFirstName, cdLastName, cdCompany FROM tviCDs SELECT @TotalRecs = @@ROWCOUNT in this code: objCommand = Server.CreateObject("ADODB.Command") objCommand.ActiveConnection =...

Hi everyone! Hope you can give me a hand with this little problem: I am developing an advanced search page that searches for actors resumes on our website (ASP and SQL Server). On this page, I have a number of fields: drop-down lists, checkboxes, etc. For example, I have a group of...

Hi everyone! Hope you can give me a hand with this little problem: I am developing an advanced search page that searches for actors resumes on our website. On this page, I have a number of fields: drop-down lists, checkboxes, etc. For example, I have a group of checkboxes that list sports...

Hey everyone! On my pages, I have set up a banner rotator that contains, for instance, Image objects with their .src properties pointing to image files and stuff like that. However, when I change the content of the .js file, the page into which it is included via <script src=*.js> does not...

Hi everybody, I have this weired problem with FileSystemObject. It does not seem to let me access the File objects in Files collection. I am sure there are files in the folder, and I have tried it on several folders. As you can see I am using Javascript, and here is the bit of my code...

Hi, In my table Models I have a varchar field called modelName. I want to replace all underscores(_) with spaces in that field for all records in the table. Any ideas how to do it? Thanks in advance. <Dmitriy> dbrom@crosswinds.net

Hi, I know how to detect the IP address - Request.ServerVariables(&quot;REMOTE_ADDRESS&quot;) However, when I view stats provided by my webhosting provider, I see that they show user addresses in the following format: cache-rq01.proxy.aol.com pool0953.cvx6-bradley.dialup.earthlink.net Do...

Hi guys, Do you know how I can remove items from the Add/Remove menu in the control panel. I want user to be unaware that certain programs are installed. Thanks in aadvance. Dmitriy. <Dmitriy> dbrom@crosswinds.net

Hi, I use data shaping to return a child recordset as a part of the parent recordset. The parent recordset contains models from the Models tables, and it is supposed to have a field rsAccessories that would have all accessories for this model from Accessories table. Here's my SQL statement...

Hi guys, I am trying to develop an interface for the database so that a user with minimum knowledge would be able to write SQL queries from my ASP pages. I just want to do this for UPDATE, DELETE, INSERT, SELECT. So I thought it would be very nice if I could first ask user to delect a...

Hi guys, I am trying to develop an interface for the database so that a user with minimum knowledge would be able to write SQL queries from my ASP pages. I just want to do this for UPDATE, DELETE, INSERT, SELECT. So I thought it would be very nice if I could first ask user to delect a...