Cannot create web project

TheMSsForum.com: The Microsoft Software Forum

The MSS Forum ‹ ASP Server
- Archive
  - Biz
  - MCSE
  - CRM
  - Drivers
  - Framework
  - ADO
  - ASP
  - Compact
  - Forms
  - Dotnet
  - C#
  - VB
  - FontpageGen
  - Excel
  - WorkSheet
  - Exchange
  - Setup
  - Fox
  - Fontpage
  - ASP
  - IIS
  - Entourage
  - Money
  - Messanger
  - PocketPC
  - Powerpoint
  - Project
  - Publisher
  - Excel
  - VB
  - Security
  - Portal
  - Services
  - SQLServerDev
  - SVCS
  - SQLServer
  - VB
  - VC
  - MFC
  - ExcelGen

- Previous
  - 1
    - asp and ms sql This is a table created in ms sql: create table customer ( CustomerID int IDENTITY, FirstName varchar(25), LastName varchar(25), CompanyName varchar(25), Phone int, Email varchar(20), Password varchar(20), Address varchar(30), Zip int, StateID varchar(30), City varchar(30), CountryID varchar(30), CustomerTypeID varchar(30), Session varchar(30), IP varchar(30), LastUpdate Smalldatetime ) This is the stored procedure created in ms sql: Create Procedure usp_InsertCustomer @FirstName varchar(25), @LastName varchar(25), @CompanyName varchar(25), @Phone int, @Email varchar(20), @Password varchar(20), @Address varchar(30), @Zip int, @StateID varchar(30), @City varchar(30), @CountryID varchar(30), @CustomerTypeID int, @IP varchar(20) AS SET NOCOUNT ON Declare @sessionID AS UNIQUEIDENTIFIER Declare @session AS varchar(255) set @sessionID = NEWID() set @session = convert(varchar(255),@SessionID) INSERT INTO Customer FirstName,LastName,CompanyName,Phone,Email,Password,Address,Zip,StateID, City,CountryID,CustomerTypeID,Session,IP,LastUpdate VALUES(@FirstName,@LastName,@CompanyName,@Phone,@Email,@Password,@Addres s,@Zip,@StateID,@City,@CountryID,@CustomerTypeID,@session,@IP,GETDATE()) In my RegistrationExec.asp I have the following code:    <% firstname = formatforDb(getUserInput(Request.Form("textfield1"))) lastname = formatforDb(getUserInput(Request.Form("textfield2"))) companyname = formatforDb(getUserInput(Request.Form("textfield3"))) phone = formatforDb(getUserInput(Request.Form("textfield4"))) email = formatforDb(getUserInput(Request.Form("textfield5"))) password = formatforDb(getUserInput(Request.Form("textfield6"))) address = formatforDb(getUserInput(Request.Form("textfield7"))) zip = formatforDb(getUserInput(Request.Form("textfield8"))) state = formatforDb(getUserInput(Request.Form("select1"))) otherstate = formatforDb(getUserInput(Request.Form("textfield9"))) city = formatforDb(getUserInput(Request.Form("textfield10"))) country = formatforDb(getUserInput(Request.Form("select2"))) if isLength(firstname) = false then response.redirect "error_msg?msg=Please fill in the first name." end if if isLength(lastname) = false then response.redirect "error_msg?msg=Please fill in the last name." end if if isLength(companyname) = false then response.redirect "error_msg?msg=Please fill in the company name." end if if isLength(phone) = false then response.redirect "error_msg?msg=Please fill in the phone number." end if if isLength(email) = false then response.redirect "error_msg?msg=Please fill in the email address." end if if isLength(password) = false then response.redirect "error_msg?msg=Please fill in the password." end if if isLength(address) = false then response.redirect "error_msg?msg=Please fill in the address." end if if isLength(zip) = false then response.redirect "error_msg?msg=Please fill in the zip code." end if if (isLength(state) = true AND isLength(otherstate) = true) OR (isLength(state) = false AND isLength(otherstate) = false) then response.redirect "error_msg?msg=Please fill in or select a state." end if if isLength(city) = false then response.redirect "error_msg?msg=Please fill in the city." end if if isLength(country) = false then response.redirect "error_msg?msg=Please select a country." end if if isEmail(email) = false then response.redirect "error_msg?msg=You have entered an invalid email address." end if if isZip(zip) = false then response.redirect "error_msg?msg=You have entered an invalid zip code." end if if isPhone(phone) = false then response.redirect "error_msg?msg=You have entered an invalid phone number." end if Dim Temp if isEmpty(state) then Temp = otherstate else Temp = state end if mySQL = "EXECUTE usp_InsertCustomer @FirstName='" & firstname & "',@LastName='" & lastname & "',@CompanyName='" & companyname & "',@Phone='" & phone & "',@Email='" & email & "',@Password ='" & password & "',@Address='" & address & "',@Zip='" & zip & "',@StateID='" & "kl" & "',@City='" & city & "',@CountryID='" & country & "',@CustomerTypeID=" & CInt(1) & ",@IP='" & Request.ServerVariables("REMOTE_HOST") & "'" call updateDB(mySQL, rs) rs.close() CloseDB() %> I am getting this error: Error Type: Microsoft OLE DB Provider for SQL Server (0x80040E57) String or binary data would be truncated. /Mix/database_Function.asp, line 15 How do I solve this problem?. Your help is kindly appreciated. Regards Eugene Anthony *** Sent via Developersdex http://www.developersdex.com *** Tag: Cannot create web project Tag: 312802
  - 2
    - Various path/path/files.asp all #include this 1 file Ok, I give up. I need to #include the same 1 file (IncludeThis.asp) into 3 different asp files. 1> C:\MyDir\ThisFile.asp 2> D:\MyDir\AASubSub\ThatFile.asp 3> E:\MyDir\CCSub\DDSubSub\AnotherFile.asp On another server... those same 3 files... need to include their own local copy of IncludeThis.asp 4> D:\EEDir\ThisFile.asp 5> E:\FFDir\GGSubSub\ThatFile.asp 6> F:\HHDir\IISub\JJSubSub\AnotherFile.asp Is there a way I can make an #include statement that I can put in the files... that will still find the IncludeFile.asp... regardless of the different drives, different paths, different levels of dir nesting? (Base filenames 1,2,3... are the same as 4,5,6, respectively.) The include-file will always be called IncludeThis.asp (Where should I put it?) Tag: Cannot create web project Tag: 312801
  - 3
    - DLL! I created a simple DLL in VB 6.0 & successfully registered it with the following command at the Command Prompt: regsvr32 c:\Inetpub\wwwroot\FetchRecords.dll I am accessing the DLL in an ASP page with the following code: <% Dim strProduct strProduct=Request.QueryString("product") Dim objProduct Set objProduct=Server.CreateObject("FETCH.RECORDS") objProduct.setString(strProduct) Response.Write("Price of " & strProduct & " is $") Response.Write(objProduct.retrieveRecords()) Set objProduct=Nothing %> But the above code, when executed, throws a "Invalid ProgID" error. Where am I going wrong? Please note that registering the DLL using regsvr32 throws a DllRegisterServer in c:\Inetpub\wwwroot\FetchRecords.dll succeeded. message implying that the DLL has registered successfully. In order to ensure that the component has really been installed in my system, I executed the following script: <% If(IsObject(Server.CreateObject("FETCH.RECORDS"))) Then Response.Write("Component Installed!") Else Response.Write("Component Not Installed!") End If %> but strangely, the above script also generates the "Invalid ProgID" error. Why so though the DLL has registered successfully (as the DOS message suggests)? Lastly, can DLLs be created using VS.NET 7.0 in the same way as they can be created using VB 6.0? Thanks, Arpan Tag: Cannot create web project Tag: 312800
  - 4
    - Creating 'vanity' domain names on the fly Hi - Any help or pointer on this would be greatly appreciated. I'm working on something similar to blogger.com. Users sign up and they get their own webpage, with a domain name of 'username.blogger.com'. Since blogger.com is doing it on the fly (as you sign up), I'm sure they are doing it programmatically. Anyone has any clue on how they do that? Cheers, Steve. Tag: Cannot create web project Tag: 312797
  - 5
    - returning date with two digit year I have a field that is stored in SQL Server in date/time format. On one page, I only need the date to display. I am able to do this by saying: DateValue(strLastModified) However, this returns to me the date in this format: 05/10/2004 Instead, I would like to see: 05/10/04, but I am not sure how to do this. Tag: Cannot create web project Tag: 312776
  - 6
    - DateTime in Paramtized asp query? How does one paramtized a date in asp for a stored procedure that is expecting DateTime? if oRS.eof then '// SAFE TO INSERT STORY.... CREATE Procedure spr_AddStory oCmd.Parameters.append oCmd.CreateParameter("StoryTitle", adVarChar, adParamInput,100,pStoryTitle) oCmd.Parameters.append oCmd.CreateParameter("StoryDate datetime, '//??????????????) Thanks Jason Tag: Cannot create web project Tag: 312767
  - 7
    - Fine-tune/improve Parametized query in asp? I am trying to improve the robustness and elegance of my parametized sql statements in ASP 3.0 as they get passed to the sql server SP. Could anyone tell me if there are weaknessess in the way I have written the following code? I have included both the asp code and the sql stored proceducre to tie things togoether....I appreciate any advice on this. It basically is a application to manage static news stories on our site by tracking and organising the meta data in a table. Many thanks for you comments. ASP PARAMERT QUERY ---------------------------- If oRS.eof then '// SAFE TO INSERT STORY.... CREATE Procedure spr_AddStory oCmd.Parameters.append oCmd.CreateParameter("StoryTitle", adVarChar, adParamInput,100,pStoryTitle) oCmd.Parameters.append oCmd.CreateParameter("StoryURL", adVarChar, adParamInput,150,pStoryURL) oCmd.Parameters.append oCmd.CreateParameter("StoryBlurb", adVarChar, adParamInput,1200, PStoryURL) oCmd.Parameters.append oCmd.CreateParameter("StoryBrokerID int", adInteger, adParamInput,4,pStoryBrokerID) oCmd.Parameters.append oCmd.CreateParameter("StoryCompanyID int", adInteger, adParamInput,4,pStoryCompanyID) oCmd.Parameters.append oCmd.CreateParameter("StoryCategoryID int", adInteger, adParamInput,4,pStoryCategoryID) oCmd.Parameters.append oCmd.CreateParameter("StoryDeptID int", adInteger, adParamInput,4,pStoryDeptID) oCmd.Parameters.append oCmd.CreateParameter("StoryKeyword1", adVarChar, adParamInput,50,pStoryKeyword1) oCmd.Parameters.append oCmd.CreateParameter("StoryKeyword2", adVarChar, adParamInput,50,pStoryKeyword2) oCmd.Parameters.append oCmd.CreateParameter("StoryKeyword3", adVarChar, adParamInput,50,pStoryKeyword3) oCmd.Parameters.append oCmd.CreateParameter("RelatedURL1", adVarChar, adParamInput,150,pRelatedURUL1) oCmd.Parameters.append oCmd.CreateParameter("RelatedURL2", adVarChar, adParamInput,150,pRelatedURUL1) oCmd.Parameters.append oCmd.CreateParameter("RelatedURL3", adVarChar, adParamInput,150,pRelatedURUL1) oCmd.Parameters.append oCmd.CreateParameter("StoryDate datetime, oCmd.Parameters.append oCmd.CreateParameter("StoryImageURL", adVarChar, adParamInput,150,pStoryImageURL) oCmd.Parameters.append oCmd.CreateParameter("StoryBLN int", adInteger, adParamInput,4,pStoryBLN) set oReturn = oCmd.CreateParameter("u_id", adInteger, adParamOutput) oCmd.Parameters.append oReturn oCmd.execute() '//RESULT... if oReturn.value=-1 then Response.write "FAILURE: Insert statement could not be carried out" response.end else Response.write "SUCCESS: Insert statement was successfull" End if SQL SERVER STORED PROCEDURE ------------------------------------------- CREATE Procedure spr_AddStory @StoryTitle varchar(100), @StoryURL varchar(150), @StoryBlurb varchar(1200), @StoryBrokerID int, @StoryCompanyID int, @StoryCategoryID int, @StoryDeptID int, @StoryKeyword1 varchar(50), @StoryKeyword2 varchar(50), @StoryKeyword3 varchar(50), @RelatedURL1 varchar(150), @RelatedURL2 varchar(150), @RelatedURL3 varchar(150), @StoryDate datetime, @StoryImageURL varchar(150), @StoryBLN int AS INSERT INTO Story (StoryTitle, StoryURL, StoryBlurb, StoryBrokerID , StoryCompanyID, StoryCategoryID, StoryDeptID, StoryKeyword1, StoryKeyword2, StoryKeyword3, RelatedURL1, RelatedURL2, RelatedURL3, StoryDate, StoryImageURL, StoryBLN) VALUES (@StoryTitle,@StoryURL,@StoryBlurb,@StoryBrokerID,@StoryCompanyID,@StoryCategoryID,@StoryDeptID,@StoryKeyword1,@StoryKeyword2,@StoryKeyword3, @RelatedURL1,@RelatedURL2,@RelatedURL3,@StoryDate,@StoryImageURL,@StoryBLN) GO Tag: Cannot create web project Tag: 312764
  - 8
    - Downloading files of known mime type I am attempting to write an ASP page that will download a file rather then open it, when it is of known type. I found this code here: http://mosley.arach.net.au/dev/docs/save%20as.htm The first example works fine, for files under 5 Mb, the second example downloads the file but the data is corrupted. Using a JGP file as a reference, it seems to corrupt the end of the file (since the bottom of the JPEG is corrupted). Here is the code I am using. Any idea how to fix this? or an alternative method? Response.ContentType = "application/x-unknown" Response.AddHeader "content-disposition","attachment; filename=" & Request.QueryString("File") Set adoStream = CreateObject("ADODB.Stream") chunk = 2048 adoStream.Open() adoStream.Type = 1 adoStream.LoadFromFile(Server.MapPath(vFilePath)) iSz = adoStream.Size Response.AddHeader "Content-Length", iSz For i = 1 To iSz \ chunk If Not Response.IsClientConnected Then Exit For Response.BinaryWrite adoStream.Read(chunk) Next If iSz Mod chunk > 0 Then If Response.IsClientConnected Then Response.BinaryWrite objStream.Read(iSz Mod chunk) End If End If adoStream.Close Set adoStream = Nothing Response.End Tag: Cannot create web project Tag: 312762
  - 9
    - Detecting a file upload Hi all. I have a form that also allows an image to be uploaded. <input type="file" name="Upload"> How can I detect if a file has been uploaded, example if [upload has been made] then Do thing A else Do thing B end if Thanks for any pointers Tag: Cannot create web project Tag: 312761
  - 10
    - connecting to localhost Hi, I have got a scenario where an asp script needs to request via xmlhttp a file sitting on the same server. The code all works find on my local machine. However, on the hosting server, it does not. The problem is that I am on a shared server and the server can't "see itself", i.e. it's probably blocked by the host to receive request from itself. The problems comes in as the server will hold multiple sites and use host headers to channel request. I thought of using "localhost" and some kind of header sending scenario to get the server to go to the correct subfolder/virtual host. However, googling has not brought up much. Has anyone got ideas/similar scenarios and could point me in some helpful directions? Thanks Christoph Tag: Cannot create web project Tag: 312760
  - 11
    - Object doesn't support this property or method: 'Response.Redirect I wanted to add this method to my .asp page in order to dynamically choose a page based upon some selection criteria. It's in my .asp book and in the online reference. Yet when I use this object, the following error returns in the browser: Error Type: Microsoft VBScript runtime (0x800A01B6) Object doesn't support this property or method: 'Response.Redirect' /testwebs/choose.asp, line 22 What is missing from my IIS libraries in order to use have this method supported? Thanks for any info /peter d. Tag: Cannot create web project Tag: 312750
  - 12
    - why use htmlencode Hi I have a website where people can enter comments into a textarea - some of these may have a bit of html - like links - or <blockquote> the comments are stored in a Access2000 mdb file - A friend told me that i have to use htmlencode on the textarea string before storing it in the database. but it seems to work fine without doing this - is there any reason as to why i should put it thru htmlencode? when the comments are displayed they are written straight into a <div> <div><%=recset.fields("comments")%></div> thanks in advance Diablo Tag: Cannot create web project Tag: 312743
  - 13
    - error with aspnet_isapi.dll Win2k server that recent;y had a virus (fixed by client so I don't know which one it was) is filling the event log with this error: 7/6/2005,4:39:07 PM,Perflib,Error,None,1008,N/A,SERVER,"The Open Procedure for service ""ASP.NET_1.1.4322"" in DLL ""C:\WINNT\Microsoft.NET\Framework\v1.1.4322\aspnet_isapi.dll"" failed. Performance data for this service will not be available. Status code returned is data DWORD 0. " They didn't have SP4 installed so I had them install that but they tell me that the logging continues. Perfmon isn't running so what else could cause this error? I am going to TS into their machine tonight after closing so I am looking for ideas. I searched the KB and didn't find anything this specific. Perhaps reinstalling the framework will fix it? thanks for any help. Tag: Cannot create web project Tag: 312731
  - 14
    - How do I detect which button was clicked on "save/open/cancel" dialog? When users clicked a unkown mime type link such as Zip on my website, a "Save/Open/Cancel" dialog box pops up. Is there a way to detect which button users clicked by using ASP? actually I only what to record the "valid" click -- when Open/Save was clicked. Thanks ahead. Quinn Tag: Cannot create web project Tag: 312730
  - 15
    - error with aspnet_isapi.dll Win2k server had a virus, I don't know which one as the client removed it themselves, but the event log is filling with this error: 7/6/2005,4:39:07 PM, Perflib Error None1008,N/A,SERVER,"The Open Procedure for service ""ASP.NET_1.1.4322"" in DLL ""C:\WINNT\Microsoft.NET\Framework\v1.1.4322\aspnet_isapi.dll"" failed. Performance data for this service will not be available. Status code returned is data DWORD 0. " Tag: Cannot create web project Tag: 312729
  - 16
    - Having Web Page Refresh and go to end of page I am trying to use the following to get a web page to auto refresh every 3 secs and go to the end of the web page. Refresh works but it will not jump to the name anchor. Any help? <HTML> <HEAD> <META http-equiv="REFRESH" content="3;'what.htm#TheEnd'"> </HEAD> <BODY bgcolor="#ffffff" text="#000000"> <CENTER> <TABLE width="600"> <TR> <TD vAlign=top align=left> Tons o content </TD> </TR> </TABLE> </CENTER> <A name="TheEnd">You Are At The End</A> </BODY> </HTML> Tag: Cannot create web project Tag: 312724
  - 17
    - How do I get ASP (SOAPtoolkit3) to query NTLM authenticated .NETWe Hi there, I am needing to query a .NET webservice from a classic ASP page. It works absolutely fine under anonymous authentication however I want to turn NTLM authentication on in order for me to ascertain the requesting user's context. Detailed below is my code currently but it throws a very vague error when I turn on NTLM authentication. What is is that I am doing wrong and what do I need to do to get this working...? function callAuditService() Dim oSOAP Dim Result Result = False Set oSOAP = Server.CreateObject("MSSOAP.SoapClient30") oSOAP.ClientProperty("ServerHTTPRequest") = True oSOAP.mssoapinit(Application("AuditWebServicePath")) oSOAP.ConnectorProperty("AuthUser") = Request.ServerVariables("AUTH_USER") oSOAP.ConnectorProperty("ConnectTimeout") = 300000 Result = oSOAP.AuditSearch(ParametersInHere) Set oSOAP = Nothing callAuditService = Result end function Any help would be very muchly appreciated. Thanks, DC -- </davidChristiansen> Tag: Cannot create web project Tag: 312713
  - 18
    - Defending against SQL injection.... I have a multi-page ASP web application that uses information sent to it from the client in the Request.Forms collection, the Request.QueryString collection and the Request.Cookie collection. What I want to do is to sanitise ALL the information sent to EVERY page. I thought I'd achieve this by having an INCLUDE file inserted at the top of EVERY page. This include file iterates through EVERY form, querystring and cookie item and removes anything that looks like malicious SQL injections from the values. Having completed this task, the many web pages then access the sanitised Request object with impunity. One minor drawback is that it doesn't seem to work...I can't update the Request object with the sanitised value. [Error message: VBScript runtime error: Object doesn't suppor this property or method] Either it's something silly in my coding or it's the wrong approach....please advise accordingly (code below). Thanks Griff --------------------------------------------------------------------------------------------- Dim asSQLInjectionWords ' Array to hold the injection keywords Dim oRequestItemName ' Item in the request object (form, querystring and cookies) Dim vValue ' Item value ' Populate the array populateArray asSQLInjectionWords ' Sanitise the request form objects for each oRequestItemName in Request.Form ' Load the value vValue = Request.Form(oRequestItemName) ' sanitise the request item value Request.Form(oRequestItemName) = sanitiseItemValue(asSQLInjectionWords, vValue) next 'oRequestItem ' Sanitise the request query string objects for each oRequestItemName in Request.QueryString ' Load the value vValue = Request.QueryString(oRequestItemName) ' sanitise the request item value Request.QueryString(oRequestItemName) = sanitiseItemValue(asSQLInjectionWords, vValue) next 'oRequestItem ' Sanitise the request cookie objects for each oRequestItemName in Request.Cookies ' Load the value vValue = Request.Cookies(oRequestItemName) ' sanitise the request item value Request.Cookies(oRequestItemName) = sanitiseItemValue(asSQLInjectionWords, vValue) next 'oRequestItem ' Erase the array erase asSQLInjectionWords ' ------------------------------------------------------------- private function sanitiseItemValue(byRef injectionArray, byVal vValue) Dim iArrayCounter Dim aRequestItem ' Iterate through the sql injection array for iArrayCounter = 0 to ubound(injectionArray) ' Split the request item's value around the SQL injection term aRequestItem = split(vValue, injectionArray(iArrayCounter)) ' Rebuild the request item with out the SQL injection term vValue = join(aRequestItem, vbNullString) next ' Return sanitised value sanitiseItemValue = vValue end function ' ------------------------------------------------------------- private sub populateArray(byRef injectionArray) injectionArray = Array(_ "/", _ "\", _ "'", _ """", _ ";", _ "=", _ "--", _ "*", _ ".", _ "create", _ "dbcc", _ "dbo", _ "delete", _ "drop", _ "exec", _ "index", _ "insert", _ "from", _ "having", _ "inner", _ "join", _ "master", _ "model", _ "msdb", _ "null", _ "table", _ "tables", _ "tempdb", _ "truncate", _ "union", _ "update", _ "where", _ "xp_cmdshell", _ "xp_startmail", _ "xp_sendmail", _ "xp_makewebtask") end sub ' ------------------------------------------------------------- Tag: Cannot create web project Tag: 312710
  - 19
    - How to get/set and send the HTTP Headers(user-defined) [Qtn : How to get/set and send the HTTP Headers(user-defined) coming from another domain/site] Hi Experts, In one SMS gateway project i need a great and urgent help from u all. There, the Service Providers sending the data thru "HTTP Headers" (For ex. sms-Id,sms-source [user defined]). So i need to get and parse the name value pairs, and need to respond/send the same way as coining the "HTTP Headers" (For ex. sms-Id,sms-destination,sms-msg [user defined]). Pls its urgent. thanx in advance Laks.R Tag: Cannot create web project Tag: 312707
  - 20
    - URLDecode for UTF8 Hello, I have a URLDecode function which works fine for all characters except for UTF8 characters. If I server.URLEncode the string "å??", the resultant string is "%E5%95%86". How do I convert it back to the original string? Thank you. Tag: Cannot create web project Tag: 312706
  - 21
    - Use session variables or store in database? I'm new to ASP. If I store information in these handy "session variables" am I going to run into many limitations that I wouldn't have it I added a database record for each session instead? For example, if I use session variables, can I have an admin utility that lets me see a list and/or count of all open sessions? Or would I be able to keep the same user from starting multiple sessions if I wanted (by comparing the log-in name which my web-site requires)? I know if I create a record for each open session that I can do all kinds of fun stuff like reports and queries, but not sure if I'll have all of those options with these built in ASP session variables (which I imagine ASP stores in memory or some non-standard format). p.s.-I'm using ASP (not ASP.NET) with VBScript (I hate VB syntax but that is what everyone seems to use). Tag: Cannot create web project Tag: 312703
  - 22
    - List of Databases I am writing an Active Server Page application that will get all of the databases that a user can access. Is there a way I can do this with Active Server Pages? I also will provide the users with the option to change records, table structure, etc with this application. I will also be developing an asp.net (C#) project that will do the same thing. If anyone can provide code snippets or anything that would be great. Thanks, Rick Langschultz Web Developer/IT Manager Tag: Cannot create web project Tag: 312701
  - 23
    - number formatting Hi Im having a problem getting a number to display correctly. The number is the result of a calculation and I am then using formatnumber to remove any decimals. The number displays as '1,345' is there any way to get rid of the comma Thanks J Tag: Cannot create web project Tag: 312695
  - 24
    - info@service-now.com Dear Mr. Lindsey, This is Guojun Zhu, an intern in Capital Hunter. We are a research company in San Diego, California, focused on the equity financing on venture capital. I would apprecieate if you can send me the information about the management such as CEO, CFO, etc. Thanks for your attention and have a great day! -- Guojun Zhu gzhu@capitalhunter.com Capital Hunter, Inc. 751 Seventh Avenue, Suite O San Diego, CA 92101 619-236-9998 http://www.capitalhunter.com Tag: Cannot create web project Tag: 312693
  - 25
    - Excel gridlines Like many people here, I've been trying to generate a spreadsheet on an ASP page. In my case, it's Intranet, so I can't provide you with a link. But the problem I have been fighting is a simple one: The spreadsheet that is built by my code has no gridlines. I cannot find anything in the documentation of either MSDN (for ASP) or Excel that tells me how to code my page in such a way that it looks like Excel normally looks when you bring it up. In my HTML code, I have tried <table border="1" as well as just taking the border attribute out. I have seen this work in other people's ASP code, but don't have access to their code. Any help appreciated. Tag: Cannot create web project Tag: 312687
- Next
  - 1
    - SQL Conversion Assistance Needed Came across this code. SELECT Y, Q1 = COUNT(CASE WHEN Q=1 THEN Sales END), Q2 = COUNT(CASE WHEN Q=2 THEN Sales END), Q3 = COUNT(CASE WHEN Q=3 THEN Sales END), Q4 = COUNT(CASE WHEN Q=4 THEN Sales END) FROM dbo.SalesByQuarter GROUP BY Y ORDER BY Y It does a pivot table type deal. How would I convert this to a one line SQL statement? Is this possible. Tag: Cannot create web project Tag: 312680
  - 2
    - Flushing servers buffer In the following code when i = 500 the buffer on the server is flushed to the client. However, because the content that is sent to the browser contains an html table Internet Explorer does not display the table until it receives the closing </table> tag. The question is, am I correct in saying that the buffer on the server is CLEARED when i = 500? It will be empty for a split second until the loop resumes again. Am I correct? Dim i i = 1 Response.Write("<table>") For i = 1 to 1000 Response.Write("<tr><td>" & i & "</td></tr>") i = i + 1 If i = 500 Then Response.Flush() End If Loop Response.Write("</table>") Is this a good way to clear the buffer if I'm processing a very large amount of data? Tag: Cannot create web project Tag: 312677
  - 3
    - Shopping Cart Advised Hi All, If I want to using asp paging to display product. I added 2 pcs in page 1, and I added 3pcs in page 2, and I added 5pcs in page 4 and then click add to cart button. How can I keep them before click "add to cart" button ? Please advised. Tag: Cannot create web project Tag: 312672
  - 4
    - Prevent "Back" Buttom in Browser I am trying to set up a login-logout website. I have a cookie about the login status. I put it as logout once the logout link is clicked. And I put a little security check about the status of the cookie variable everytime before loading the detailed member profiling. The page layout is like: Login page,-->check the login name/password database-->profile page(only login cookie is true, redirect back to login if false) Logout link, set login cookie as false and redirect to the login page. However, after I check a profile and then click logout, I can still get back to profile page by click "back" button in browser. I was told those are in the browser cache and the check of the "login" cookie does not actually work in this situation. Is there anyway to force the browser to clear the cache after I click the "logout". It should be possible since lots of websites do that. I just do not how to. Any help is highly appreciated! Tag: Cannot create web project Tag: 312666
  - 5
    - Problems connecting to MS SQL via Access2000 adp For the past several projects, I have been using an Access 2000 .adp file to create and manage the database on the remote SQL Server. It has worked very well for me and is a very fast, simple way to take care of minor updates. A new project is not going so well, though. No matter what I try, I can not get a connection established. This project is on a server I do not control, so I am having to work only with the information provided to me by the admin. Using an online admin tool provided by the server administrator, I am able to log in and view the database and make edits via manually written SQL statements. However, using the server name provided and the same login info, I am unable to establish a connection through Access. The admin also told me to use a file-based DSN connection in my ASP pages; I have always used DSN-less in the past, and can not figure out why a DSN would be required. Could there be any connection between this and not being able to connect via Access? Any suggestions or ideas would be appreciated. Thank you. Paul Tag: Cannot create web project Tag: 312646
  - 6
    - Random Session Timeout in IIS6 I have an asp application running on both iis5 and iis6. (not .net) The server ruhnning IIS5 has no problem running my application. IIS6 randomly times out WEB users. The session timeout is set for 60 minutes. I will get timed out in iis6 in less than 5 minutes. Are there any other settings that can be changed to stop this from happening Tag: Cannot create web project Tag: 312643
  - 7
    - 401.2 on ASP pages Argh! I know this is a simple problem, but I just can't find the answer. I have IIS running and can get it to display htm pages, but not ASP. I get 401.2, invalid config on server. I've run authdiag, but can't glean the answer from its results. All help appreciated! Steve Tag: Cannot create web project Tag: 312640
  - 8
    - How to convert XML or HTML to pdf file ? Hi all, How to convert XML or HTML to pdf file ? Where can I find free pdf generator ? Tag: Cannot create web project Tag: 312635
  - 9
    - need help to set up Natterchat 1.12 Hi everybody! May be somebody has experience in installing Natterchat 1.12 on [url]www.7host.com?[/url] I will appreciate any help and assistance -- alan_ot ------------------------------------------------------------------------ Posted via http://www.codecomments.com ------------------------------------------------------------------------ Tag: Cannot create web project Tag: 312630
  - 10
    - session In my login.asp I have the following code:  <% Dim sSessionID, sMessage If Len(Request.Form("cmdSubmit")) > 0 then mySQL = "EXECUTE usp_CheckLogin @usid='" & Trim(Lcase(Request.Form("usid"))) & "',@password='" + Trim(Request.Form("password")) & "'" call updateDB(mySQL, rs) sSessionID = rs.Fields(0).Value rs.close() CloseDB() end if if Len(Trim(Lcase(Request.Form("usid")))) > 0 AND Len(Trim(Request.Form("password"))) > 0 then If sSessionID = -1 Then SMessage = "username or password invalid" else response.write "<input type='hidden' name='sSessionID' value=" & sSessionID & ">" Response.Redirect ("home.asp?id=" & sSessionID) end if end if %> <html><head><title>login page</title></head> <body> <form method="post" action="login.asp"> <table> <tr><td colspan="2"><h3>Login Page</h3></td></tr> <tr><td colspan="2"><% = sMessage%></td></tr> <tr> <td>user name<td> <td><input type="text" name="usid" value="<% = Request.Form("usID")%>"></td> </tr> <tr> <td>password<td> <td><input type="password" name="password" value="<% = Request.Form("password")%>"></td> </tr> <tr> <td> <td> <td><input type="submit" name="cmdSubmit" value="login"></td> </tr> </table> </form> </body> </html> In my home.asp I have the following code:  <% if Len(Request.QueryString("id")) = 0 then response.redirect "login.asp" end if Tem = Trim(Lcase(Request.QueryString("id"))) Tem = replace(Tem,"{","") Tem = replace(Tem,"}","") mySQL = "EXECUTE usp_CheckSessionID @sessionID='" & Tem & "'" call updateDB(mySQL, rs) if rs.Fields(0).Value = -1 then response.redirect "login.asp" end if CloseDB() %> In my database_Function.asp I have the following code: <% dim objConn,rs sub openDB() set objConn = Server.CreateObject("ADODB.Connection") objConn.Open "PROVIDER=SQLOLEDB;DATA SOURCE=127.0.0.1;UID=mama;PWD=papa;DATABASE=Godson" end sub sub updateDB(SQL,rs) openDB() set rs = objConn.Execute(SQL) end sub sub getFromDB(SQL,rs,filename) openDb() set rs = Server.CreateObject("ADODB.Recordset") rs.lockType = adLockReadOnly rs.cursorType = adOpenStatic rs.Open SQL, objConn end sub sub closeDB() objConn.Close set objConn = nothing end sub %> These are tables and procedures created in ms sql: create table tbl_users ( SessionID varchar(255) Primary Key, usID Varchar(20), Password Varchar(20), LastUpdate Smalldatetime ); Create Procedure usp_CheckSessionID @sessionID Varchar(255) As SET NOCOUNT ON if EXISTS(SELECT top 1 * FROM tbl_users WHERE sessionID=@sessionID AND DATEDIFF(n,LastUpdate,GETDATE())<=20) begin update tbl_users set LastUpdate = GETDATE() WHERE sessionID=@sessionID Select 0 end else Select -1 Return GO create procedure usp_CheckLogin @usID Varchar(20), @password varchar(20) As SET NOCOUNT ON Declare @sessionID as UNIQUEIDENTIFIER Declare @session as Varchar(255) if exists(Select top 1 * from tbl_users where usID=@usID AND password=@password) Begin set @sessionID = NEWID() set @session = CONVERT(Varchar(255),@sessionID) Update tbl_users Set sessionID=@session,LastUpdate=GetDate() where usID = @usID and password = @password Select @sessionID End else Select -1 Return GO Everything works fine. However there is a problem. The problem is: In my login.asp page requires me to enter the username and password. It works fine. When I enter a valid username and password it will redirect me to home.asp with a link as followed for example http://localhost/Eugene/home.asp?id={D8E3C5D2-DEFD-4F99-8F35-AC0CF848150 5}. This works fine. However in terms of security this link http://localhost/Eugene/home.asp?id={D8E3C5D2-DEFD-4F99-8F35-AC0CF848150 5} will work for as long as (SELECT top 1 * FROM tbl_users WHERE sessionID=@sessionID AND DATEDIFF(n,LastUpdate,GETDATE())<=20) even when I close my browser window, open it again and type http://localhost/Eugene/home.asp?id={D8E3C5D2-DEFD-4F99-8F35-AC0CF848150 5}. Is there a way to keep id={D8E3C5D2-DEFD-4F99-8F35-AC0CF8481505} hidden across different pages for security purpose without using session variables, cookies and querystring. Your help is kindly appreciated. Regards Eugene Anthony *** Sent via Developersdex http://www.developersdex.com *** Tag: Cannot create web project Tag: 312628
  - 11
    - DTPicker Hi Guys, A silly question really, but how do I get the value of a DTPicker. I just need to get the value in session variable and display it on a different page. ----------------------------- This message is posted by http://asp.forumszone.com Tag: Cannot create web project Tag: 312615
  - 12
    - Generating XLS files from ASP Hi All, I'm generating XLS files from ASP(.Net) code using the usual code chunks ... Response.ContentType = "application/vnd.ms-excel" Response.AppendHeader("Content-Disposition", "attachment; filename=""" & NomeFile & """") Response.Flush() Response.write("<table border=""1"" ..... ..... ..... Response.end It all works fine since I'm able to Open/Save the file with Excel 2000. But .... ...... when I run the code on a box where only an Excel Viewer 2003 is installed (rather then the full product) I cannot open it, and Viewer aborts with the following Message : "Cannot Open files of this type". Choosing to save save the file to reopen it laterleads to the same error. Moreover, the generated XLS file looks to be really small ....(1Kb) and after opening and resaving it from Excel program as a xls Workbook it becomes larger (14Kb). At this point the viewer can open it.. ... All this let me think that the generated file is not a "real" xls file .... while viewer can only open this kind of files ... (also tried to use freeware viewer but I got the same behaviour .....) Any help is appreciated .... Thanks in advance Daniele Balducci Tag: Cannot create web project Tag: 312614
  - 13
    - help hiding image paths anyone know a useful way of hiding image paths so images on my site cant be directly linked to? ive seen sites that use <img src="image.asp?/moo/fred/image01.jpg"> (where the path starts from www.domain.com/secretfolder/moo/fred/image01.jpg) but dont know how to set this up BTW am on a shared host so dont have the use of base level administration if it makes any difference? anyone help me? mark Tag: Cannot create web project Tag: 312613
  - 14
    - Associating Iframe pages with a specific page. Server side HI! I need to associate a iframe pages to a specific page for my menu system. I want to be able to click on my menu system anywhere on my site and the options that is clicked will load that options ( iframe page ) into a specific page that holds the iframe. Right now the options are only available when on the page that holds the Iframe in question ( templates.htm )but if you are on another page ( index.htm) how do we tell it to load that option into ( templates.htm ) ? I think I need some kind of ASP script that would associate any Iframe page that I specify to the ( Templates.htm ) page. How do we do this? does anyone have any ideas/examples ? Paul Tag: Cannot create web project Tag: 312612
  - 15
    - aspx page to kick off async background task and then end I'm not sure of the best way to do what I want. Users of my website want to run reports that take a long time to generate. This is what I would like to happen: 1. User requests aspx page 2. aspx page kicks off an asynchronous background task (on the same web server) to generate the report. The end result will be a file created on the website. 3. aspx page returns this message to the user: "your report is being generated, check back in a few minutes" 4. aspx page ends. 5. (optional, the icing on the cake) A frame in the user's frameset starts (through client-side script) sending periodic requests to the server to check whether the report is ready, and displays a message box to inform the user when they can pick it up. 6. User goes to their "My Reports" page and collects the report 7. After 24 hours the report file is automatically deleted from the server Now, my question is how to do step 2. I guess it could be done with MSMQ, but is there a better way? I tried making a Windows service and making an asynchronous call to it with Delegate.BeginInvoke(). However, it doesn't seem suited to my situation because it seems to insist that the caller (the aspx page) stays alive for the end result, whereas I want the caller to terminate while the callee is still running. When my BeginInvoke() caller terminates, the callee seems to stop also. Additionally, the documentation says the caller must call EndInvoke(), which mine can't. Am I on the right track, or should I be using MSMQ? Shelling? A web service? Some kind of ThreadPool? So many technologies... Thanks in advance, Carl Johansen http://www.carljohansen.co.uk Tag: Cannot create web project Tag: 312599
  - 16
    - Windows Script I Know this is the wrong group to ask but you never know some one out there might have the answer. Does any one know how to compile windows script.? what tool do I need and how to? TIA Al. Tag: Cannot create web project Tag: 312594
  - 17
    - Asp search in progress page...How? Any suggestions to the following problem... I need a search in progress page, so when a user clicks my search button they are then directed to a 'searching...' page with an animated gif. The search in progress page needs to use 'GET' to go and retrieve the results of the search. Once the results come back they replace the search in progress page. Any help appreciated! Many thanks, Ian Tag: Cannot create web project Tag: 312583
  - 18
    - asp and ms sql Table created in ms sql: create table tbl_users ( SessionID UNIQUEIDENTIFIER Primary Key, usID Varchar(20), Password Varchar(20), LastUpdate Smalldatetime ); 2 Stored Procedures created in ms sql: Create Procedure usp_CheckSessionID @sessionID UNIQUEIDENTIFIER As if EXISTS(SELECT 1 FROM tbl_users WHERE sessionID=@sessionID AND DATEDIFF(n,LastUpdate,GETDATE())<=20) begin update tbl_users set LastUpdate = GETDATE() WHERE sessionID=@sessionID Select 0 end else Select -1 Return GO create procedure usp_CheckLogin @usID Varchar(20) @password varchar(20) As Declare @sessionID as UNIQUEIDENTIFIER if exists(Select 1 from tbl_users where usID=@usID AND password=@password) Begin set @sessionID = NEWID() Update tbl_users Set sessionID=@sessionID,LastUpdate=GetDate() where usID = @usID and password = @password Select @sessionID End else Select -1 Return GO In database_Function.asp : <% dim objConn,rs sub openDB() set objConn = Server.CreateObject("ADODB.Connection") objConn.Open "PROVIDER=SQLOLEDB;DATA SOURCE=127.0.0.1;UID=papa;PWD=mama;DATABASE=quan end sub sub updateDB(SQL,rs) openDB() set rs = objConn.Execute(SQL) end sub sub getFromDB(SQL,rs,filename) openDb() set rs = Server.CreateObject("ADODB.Recordset") rs.lockType = adLockReadOnly rs.cursorType = adOpenStatic rs.Open SQL, objConn end sub sub closeDB() objConn.Close set objConn = nothing end sub %> In my home.asp :  <% if Len(Request.QueryString("id")) = 0 then response.redirect "login.asp" end if mySQL = "EXECUTE usp_CheckSessionID @sessionID=''" & Trim(Lcase(Request.Form("id"))) & "''" call updateDB(mySQL, rs) if rs.Fields(0).Value = 0 then response.redirect "login.asp" end if CloseDB() %> In login.asp :  <% Dim sSessionID, sMessage If Len(Request.Form("cmdSubmit")) > 0 then mySQL = "EXECUTE usp_CheckLogin @usid=''" & Trim(Lcase(Request.Form("usid"))) & "'',@password=''" + Trim(Request.Form("password")) & "''" call updateDB(mySQL, rs) sSessionID = rs.Fields(0).Value rs.close() CloseDB() end if If sSessionID = -1 Then SMessage = "username or password invalid" else Response.Redirect ("home.asp?id=" & sSessionID) end if %> <html><head><title>login page</title></head> <body> <form method="post" action="login.asp"> <table> <tr><td colspan="2"><h3>Login Page</h3></td></tr> <tr><td colspan="2"><% = sMessage%></td></tr> <tr> <td>user name<td> <td><input type="text" name="usid" value="<% = Request.Form("usID")%>"></td> </tr> <tr> <td>password<td> <td><input type="password" name="password" value="<% = Request.Form("password")%>"></td> </tr> <tr> <td> <td> <td><input type="submit" name="cmdSubmit" value="login"></td> </tr> </table> </form> </body> </html> I am facing a problem in my login.asp. The problem is when I enter an invalid login ID and password it works. However when I add a valid login ID and password it takes me to a page not found of my browser. How do I solve the problem?. I have inserted 1 record in my tbl_users table to test my code. INSERT INTO tbl_users VALUES (NEWID(),"mama","papa",GetDate()) Regards Eugene ----------------------------- This message is posted by http://asp.forumszone.com Tag: Cannot create web project Tag: 312581
  - 19
    - Upload files. I need to I make an .asp page on our website where users could upload different files, like text, pdf or images. No .net environment. Could be it done with VBscript or have to use something else? Any examples or ready to use objects, any tips would be appreciated? I'm a little bit rusty but can catch up. Thanks, Michael Tag: Cannot create web project Tag: 312574
  - 20
    - removin html tags from string - but leaving a few behind hi i have seen several examples (blogs in particular) http://www.lastkissed.com/?p=7#comments where placing html into a textarea seems to be stripped out on the other side. and yet retains some... for example the above - i placed a </table> into the comment and submitted - the <blockquote> came out as a block quote but the </table> seems to have dissappeared. is there a way i can do a similar box - ie so that if someone puts html into it - it is stripped out? thanks for help Diablo Tag: Cannot create web project Tag: 312565
  - 21
    - ASP LDAP Query Error I have an ASP page that retrieves user info. The page runs fine on X Pro IIS 5.1, however, when i try to run it from a server running W2 Server SP4 or W2K3, it breaks and i get the following error: Error Type: Microsoft VBScript runtime (0x800A000D) Type mismatch Code ------------------- Set objRootDSE = GetObject("LDAP://RootDSE") strDNSDomain = objRootDSE.Get("defaultNamingContext") Set objNet = Server.CreateObject("WScript.Network") strUserName = UCase(objNet.UserName) ' Use ADO to search Active Directory. Set objCommand = Server.CreateObject("ADODB.Command") Set objConnection = Server.CreateObject("ADODB.Connection") objConnection.Provider = "ADsDSOObject" objConnection.Open "Active Directory Provider" objCommand.ActiveConnection = objConnection strBase = "LDAP://" & strDNSDomain & ""'<--Had to remove greater/less thans infront of LDAP and between "" because the forum didn't like it ' Filter on all user objects. strFilter = "(& (objectCategory=person)(objectClass=user)(sAMAccountName=" & strUserName & "))" ' Specify attribute values to retrieve. strAttributes = " distinguishedName" strQuery = strBase & ";" & strFilter & ";" & strAttributes & ";subtree" objCommand.CommandText = strQuery objCommand.Properties("Page Size") = 100 objCommand.Properties("Timeout") = 30 objCommand.Properties("Cache Results") = False Set objRecordSet = objCommand.Execute strDN = objRecordSet.Fields("distinguishedName").value Set objUser = GetObject("LDAP://" & strDN)'<--Errors here Response.Write "-- sAMAccountName: " & objUser.sAMAccountName Response.Write "-- Department: " & objUser.Department Response.Write "-- TelephoneNumber: " & objuser.telephoneNumber Set objRootDSE = Nothing Set objNet = Nothing Set objCommand = Nothing objConnection.Close Set objConnection = Nothing Set objRecordSet = Nothing Set objUser = Nothing ------------------- I have tried changing the following code: Code ------------------- From This: strDN = objRecordSet.Fields("distinguishedName").value To this: strDNTemp = objRecordSet.Fields("distinguishedName").value For Each strValue in strDNTemp strDN = strDN & strValue Next ------------------- Which works but then some fields are not returned i.e Department sAMAccount. I'm pretty sure it has to do with IIS but not sure where or how to fi it Any help would be appreciate - sunmieste ----------------------------------------------------------------------- Posted via http://www.codecomments.co ----------------------------------------------------------------------- Tag: Cannot create web project Tag: 312562
  - 22
    - response.redirect problem I am using response.redirec to do the url redirection on my login page. The login page is under http://myURL/test/dir1/login.aspx, when the user login successfully, the login page redirects the user to the default.apsx page, which is under http://myURL/test/dir1/default.aspx. When I enter the IP address of myURL in the address bar, the redirection works perfectly fine, but if I enter myURL (which is hostname) in the address bar, the redirection in login page doesn't work anymore, the login page just gets refreshed. Does anyone has ideas how to solve this problem? Thanks a lot! Tag: Cannot create web project Tag: 312553
  - 23
    - Working with dates... I'm using ASP to access an MS Access database. One issue that I'm constantly having problems with is Date/Time records. What I'd like to know is how does one work with date variables in ASP? My current problem is this... I have two variables, Mnth and Yr, which each hold an integer. Mnth holds between 1 and 12 ( a month ), and Yr holds the desired year (2005 for example). With only these two variables how can I generate a full date to use in an SQL query, such as: SELECT * From Table WHERE DateAdded>??<date value here>?? Tag: Cannot create web project Tag: 312552
  - 24
    - checking for nothing entered in an asp form post Hi, How do you check for a empty value from a form? lservice = request.form("pservice") if not isnull(lservice) then <== this doesnt work. tried "" empty string and it still didnt work. ..... I'm having problems with the fact the user didnt enter anything. The field is optional. thanks, Will Tag: Cannot create web project Tag: 312542
  - 25
    - Detect image size automatically in asp? I am writing a little script for an online album. The pictures' size varies a lot. I have a maxim size for every displayed picture because the layout of the page. So I want to resize the larger one to that size while leave the smaller one in their original size. Is there any script or code that can do this automatically? Thanks. -- Guojun Zhu gzhu@capitalhunter.com Capital Hunter, Inc. 751 Seventh Avenue, Suite O San Diego, CA 92101 619-236-9998 http://www.capitalhunter.com Tag: Cannot create web project Tag: 312535

I am trying to create a web project in Visual InterDev.

I get the message: "Cannot create a disk-based web application in
C:\InetPub\wwwroot\Project1\Project1_local. You cannot configure
C:\InetPub\wwwroot\Project1\Project1_local as a frontpage web because the
dirctory C:\InetPub\wwwroot\Project1 above it is already configured as a
frontgae web. You can open that web instead."

Does anyone have any idea what is going on here?

Top

Re: Cannot create web project by jeff

jeff
Sun Jul 10 22:51:02 CDT 2005

On Sun, 10 Jul 2005 19:22:17 -0700, "Dave"
<davefrick@newsgroup.nospam> wrote:

>I am trying to create a web project in Visual InterDev.
>
>I get the message: "Cannot create a disk-based web application in
>C:\InetPub\wwwroot\Project1\Project1_local. You cannot configure
>C:\InetPub\wwwroot\Project1\Project1_local as a frontpage web because the
>dirctory C:\InetPub\wwwroot\Project1 above it is already configured as a
>frontgae web. You can open that web instead."
>
>
>Does anyone have any idea what is going on here?

Yup. But it's not ASP related. Ask in the FrontPage groups and
they'll tell you how to replace your current disk-based web with the
new one you're trying to create. If I remember correctly, there's a
KB article on this as well you might search for.

Jeff

Top

Re: Cannot create web project by lukezhan

lukezhan
Mon Jul 11 03:23:51 CDT 2005

Yes, there are some KB articles about this error. You may first take a look:

http://support.microsoft.com/default.aspx?scid=KB;EN-US;Q191965

http://support.microsoft.com/default.aspx?scid=KB;EN-US;Q194798

Hope this help,

Luke

Top