Active Server Pages (ASP) Programming Discussion

Syntax for wildcard query in ASP 3.0

Dave - 24 Mar 2007 11:55 PM - 5 messages

This is my query named "spVOC_Sp_Example_search" in Access 2003: PARAMETERS [pSearch] Text ( 255 ); SELECT Example.Example FROM Example WHERE (((Example.Example) Like "*" & [pSearch] & "*")); It works great: I call the query, am prompted for the pSearch param value, ...

Data is not pulling from the site

colleen1980@gmail.com - 24 Mar 2007 9:58 PM - 8 messages

Hi: When i run the same code with minor changes in VB it works fine but when i run in ASP it runs but it not pulling any information from the web site. Needs help Thanks, Anna. ASP CODE Const ForAppend = 8 ...

Helga

Helga - 24 Mar 2007 9:58 AM - 2 messages

...

encrypted asp file?

Brett Evanson - 23 Mar 2007 8:53 PM - 2 messages

i have a file that i should have access to that i need to edit that looks like the content is encrypted or something. any way i can get the code out of the file? Brett ...

asp excel

magix - 23 Mar 2007 8:15 PM - 2 messages

I try to use asp to extract excel data. if the item field in excel is empty, can I use "" to represent empty ? will this (" ") work ? rs("Item") = "" rs.open "SELECT * FROM [Sheet1$]", oConn do until rs.EOF ...

ASP page displaying SQL table data

student - 23 Mar 2007 6:28 PM - 3 messages

I am struggling with this asp page. I need to solve this as part of a class project. It is designed to simply read a SQL table and display the data in the browser. But it will only show one record based on ID at a time. So if I ...

Question about pull down menus on asp forms.

Brave - 23 Mar 2007 5:50 PM - 8 messages

I have two questions about pulldown menus on forms. 1: Can I have the options of one pulldown menu be dictated by the choice from another pulldown menu (example beow)? 2: Can I have a form be submitted when a choice is made in a pulldown ...

putting a variable in parameter for a URL

ig.martix - 23 Mar 2007 3:12 PM - 2 messages

Is it possible to put a variable in parameter for a URL? I'm looking to have a page with an input box and a link. When someone puts in a value in the input box and clicks the link it will take the ...

Ajax and ASP

glbdev - 23 Mar 2007 2:31 PM - 3 messages

Does anyone know of a site where I could learn how to use Ajax with ASP? I am a complete newbie to AJAX (know the name and that's about it) but am interested to see if it could help my applications. The ...

upload image

G - 23 Mar 2007 1:48 PM - 3 messages

Hello Friend, I am handling a module using ASP3.0 which has to upload an movie clipsof size 1 mb or 2 mb. i have a code which upload only files or images. So I need your help for this. If you know any code or any free component please ...

get the my document path info

colleen1980@gmail.com - 23 Mar 2007 12:51 PM - 2 messages

Hi: Can any one please tell me how to i get the my document path infor of user computer thru ASP code. I try the VB6 code but it dont work their? Thanks. Dim DBConn,rs,social,vpath,vfile Dim WShell As Object ...

VB Function to return array to ASP

Raj - 22 Mar 2007 8:25 PM - 11 messages

I need a VB function to return array of collections like Private Type Employee empname as string address as string salary as integer deptno as integer End Type dim employees() as Employee Public Function getEmployees() as Employee() ...

comparing two recordsets?

danielle.m.manning - 22 Mar 2007 1:13 PM - 8 messages

Can someone help me figure out what is the best way to perform this task? I have to detect if there were any changes from one recordset to another. My recordset consists of a key (guid), and then three ...

error when connecting to sql server

Bart - 22 Mar 2007 8:16 AM - 11 messages

Hi, I get following error when trying to connect to a MDF file of sql server express 2005 database: "Microsoft OLE DB Service Components error '80040e21' Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done" ...

replacing characture

Jeff - 22 Mar 2007 3:22 AM - 5 messages

hey gang. I am having a problem with something. I run an online tournament site. With hosting for clans, more so then not, the clan tags contain charactures like + { [ in front of the tag letters. what I am having a problem with is if it starts with a +, it isn't picking ...

Transfer Database Output To Another Website

rn5a - 22 Mar 2007 2:39 AM - 4 messages

Assume that there's a website named [link] There are 2 ASP files & one MS-Access database file in this site. The 1st ASP file is named "SearchForm.asp" & the 2nd ASP file is named "SearchResult.asp". ...

How to store a class in a cookie and retrieve?

yootaeho - 22 Mar 2007 1:15 AM - 2 messages

Hi, I have the following script <%@LANGUAGE=Javascript%> <% var myClass = new LoginInfo(); myClass.sessionID = "1321312131"; Response.Cookies("testingCookies") = myClass; var recievedCookies = new LoginInfo(); recievedCookies = LoginInfo(Response.Cookies("testingCookies")); Response.Write(recievedCookies.sessionID); ...

HOWTO Make CStr for JavaScript on ASP w/ Request.Form and QueryStr

ATS - 21 Mar 2007 8:29 PM - 8 messages

HOWTO Make CStr for JavaScript on ASP w/ Request.Form and QueryString In ASP, Request.Form and Request.QueryString return objects that do not support "toString", or any JavaScript string operation on parameters not passed. Example: Make a TST.asp and post to it as TST.asp?STATE=TEST ...

PRB JavaScript in ASP with Request.Form

ATS - 21 Mar 2007 6:34 PM - 6 messages

PRB JavaScript in ASP with Request.Form Please help, I'm having a problem with JavaScript in ASP, where the ASP page crashes when I try to determine if data was posted from a FORM or through a QueryString. Where, if the data came through via a FORM, I want to use it 1st, but if not, ...

Error reading xml document in Asp

Pim75 - 21 Mar 2007 2:30 PM - 4 messages

Hello, I've written a simple asp code that has to read an xml file from an Asp.net webservice. The code looks like: set soapclient = Server.CreateObject("MSSOAP.SoapClient30") soapclient.ClientProperty("ServerHTTPRequest") = True soapclient.mssoapinit("http://webservice/Webservice.asmx?WSDL") ...

How can I redirect the output of Console.Writeline in an ASP.Net A

AAOM Tim - 21 Mar 2007 1:47 PM - 3 messages

And where is the output sent to in a web app? Thanks! ...

ASP input and EXCEL

anon1m0us - 20 Mar 2007 7:33 PM - 2 messages

Hi; I am waaayyy new at ASP so I am hopping someone can help me. I wrote an ASP that accepts input from a user. I need the input saved in different cells in an excel sheet. Everytime someone hits Submit, it ...

Search a string inside an xml node

lejason - 20 Mar 2007 5:12 PM - 2 messages

Hello, I am looking for a way to do a string search inside an xml. Basically, I work for a company that wants to export an XML file from and excel sheet and then have that data be presented on the web. Part ...

Execute windows services with asp.net in windows 2003 server

rmarcelo - 20 Mar 2007 4:18 PM - 2 messages

Hi,I cannot execute a services windos from asp.net, how execute a services windows from aps.net in windows 2003 server Thank's ...

generate xml without need to persist it in a file?

keyser soze - 20 Mar 2007 3:26 PM - 6 messages

hi i get data with ado i need to get a xml string from the recordset how can i get it without having to persist the recordset in a (xml) text file is there a simple way ? thanks !! ks ...

why I need to click refresh button in order to see session values

c676228 - 20 Mar 2007 4:26 AM - 6 messages

Hi all, Recently, I just found out that our program behaves differently from before. in our asp, in order to prevent data disppearing problem in form fields,we use session variable to display the field values if a customer click "back" ...

multiple image submit buttons in one form

c676228 - 19 Mar 2007 11:54 PM - 5 messages

Hi all I have the following code: I am trying to use the value of the image button to evaluate what plan the user has chosen, i.e. it request("submit1")="Basic", then the user chose basic plan ... But when I click one of the image button, the thing is different from what I ...

connecting to web service through asp classic

lambelly - 19 Mar 2007 10:14 PM - 2 messages

I can connect to a web service via asp.net, but my client is using asp classic. In asp.net I do something very simple along the lines of: CmsApi cmsService = new CmsApi(); Authenticate auth = new Authenticate(); auth.userName = userName.Text; ...

will I burn in hell for using all VARCHAR(MAX)?

mike - 19 Mar 2007 8:15 PM - 7 messages

so I keep optimizing my fields down to the minimum character length necessary i.e., varchar(15), then I find out a month later its gotta get bigger, then a few months later, bigger again, etc. Nowadays on sql server 2005 and on, how bad is it really to use varchar(max)? Is ...

SQL statement using two tables

Maximus - 19 Mar 2007 6:15 PM - 3 messages

I need some help with a SQL statement. I currently have which works: strSQL = "SELECT * FROM mstJobs WHERE JobStatus = True" I need to query against a second table but I am not sure of the correct syntax of the statement for adding another table.. somthing ...

Grids / Tables

Tim Gee - 19 Mar 2007 4:55 PM - 4 messages

Hi, I need to create a table on a web page dynamicaly - during the page load, which will fire a server side event when a cell is clicked - giving the cell details, is this possable in ASP.net, and if so could someone point me in the ...

more than 1 per row?

Jeff - 19 Mar 2007 4:49 AM - 11 messages

Hey gang. I know this is probably an easy solution, but I don't remember how to do it. I have this code; <% If rstActiveUsers.RecordCount > 0 Then ...

How to call a dll in ASP ?

fiefie.niles - 18 Mar 2007 5:09 PM - 7 messages

We have a C++ DLL that we call from VB6 program. This is how we declare the DLL in VB6: Declare Function RefSearch Lib "csearch32.dll" (ByVal path As String, ByVal findword As String, ByVal CaseSensitive As Integer) As Integer ...