ASP/MSSQL/Cookie Problem
I have taken over a e-commerce site that uses, ASP, MSSQL, stored procedures and cookies. For the most part it works fine. However for some reason when the user comes to the site for the first time (and therefore has not cookies for the site) there order does not go through properly. I have been discussing this issue on experts exchange and the situation is probably clear if you have a quick read of URL....
View Complete Forum Thread with Replies
See Related Forum Messages: Follow the Links Below to View Complete Thread
Response.cookie In Session_onstart Event And IE 6.0 Cookie Acceptance
When I set a cookie in global.asa in the sub session_onstart, even if I have "privacy" in IE 6.X set to "block all cookies" the cookie is still set, and I can get it on other pages. I can't find an article that addresses this as a specific issue. Why does the browser get the cookie when it is set in the session_onstart event even when I have "block all cookies" set?
Session Cookie Vs. Regular Cookie
I want to know what's the differences between session cookie and regular cookie. In ASP, when we create cookie, we do the following to identify an user: Response.Cookies("name") = value Is this regular cookie? How about session cookie? and when to use which?
Mssql
I have imported a list of links to MSSQL database with enterprise manager. I use ASP to show the list of links and it's description. Originally I had 8600 links in the database and I have imported 700 new one. I have checked in table and all the links exist and the table is indexed on field linkID. My asp script has worked before and there is no problem with it. I can still show all the links including the new links and it's descriptions but if I click on an old link, it goes to that site while with new imports, it just opens another example of my site (404 page set to open my index page). The link is correct since if I copy it from screen and paste in browser, it opens the page correctly.I have removed the index from table and made it again but no difference. There is also an edit function in my script, if I click on it, I will get a message that filed linkID does not exits but it clearly exists in the table and the rest of script is using it.
ASP And MSSQL
If I creat a ASP page, what do I need or how do I connect to a MSSQL database? Is it possible to connect to MySQL with an ASP page, or is it better to stick with MSSQL when creating an ASP page?
ASP (Javascript) And MSSQL XML
I was wondering if anyone could give me some pointers as to using ASP (Javascript, not VB) to get XML out of SQL. I have my storedProc with the FOR XML AUTO on the end, and that is returning a recordset with XML fine in query analyzer. I am lost as to how to output this as XML from an ASP page so I can transform it with XSL. My transform would be something like: Code:
Stable ASP/MSSQL CMS Out There
Looking for suggestions on any stable asp/MS SQL server content management systems in the market place. Any suggestions, or even places where I can look? I have quickly seen Rainbow and would like any comments from users of this CMS.
ASP/MSSQL Version
I am currently learning ASP but have a small PHP background, With PHP I used PHPMYADMIN to work with MYSQL Is there a web based Alternative for ASP and MSSQL that provides similair functionality?
ASP/VERY COMPLEX MSSQL
I have a query to one table but one of the values in the table is referencing a record from another table... here is the sql Code: strSql = "SELECT streetdate, barcode, itemname, descrip, vendor, sku, catlog, config, retail_cost, cost FROM blah WHERE (STREETDATE >='"& GSTARTDATE &"') AND (STREETDATE <='"& GENDDATE &"') ORDER BY STREETDATE, CATLOG DESC" now I have 2 things going on here... 1. vendor is just a number... there is a tblvendor that matches the number with a name (that i need.. i coudl nest another db query but figured that would be more resource intensive as this returns 1000s of records) 2. itemname is also a number that references another tblItem the sam way, I woul dlike to sort alphabetical off this somehow (is it even possable)
Update Mssql Using Csv Or Xml
Can't seem to find anything relating so forgive me if i've missed it. I'm after a way to open either a csv or xml file, then cycle through each line to see if it's in mssql, if it is update it... otherwise add it and then if it's in mssql and not the csv, remove it.Is it possable? Still learning and haven't dug into opening files, let alone this so any help would be grateful... oh and the fields are exactly the same in both
Connecting To MSSQL Db From Web
In our office we use RMS (Residential Management System) and they use an MSSQL database to store all the data. we can access this database using access and have made several...several queries to pull out info, save it to another access database, then upload it to the web and pull data from it. the server that houses the MSSQL database is online and i was wondering if it is possible to connect to it and pull out information. we wouldnt want to change anything, just view. so to connect to it, what all do i need to do?
Access Vs. MSSQL In ASP
I'm just deciding whether to use Access or MS-SQL for a web-application I'm predicting that my application will grow large enough to warrant use of MS-SQL, but I'm wondering how extensive the changes to my code that would make ...Specificially in ASP.Net, if I use ADO.Net, would I just need to modify my connection string or would it involve more extensive modifications?
Stored In MSSQL
I am new to programming and I managed to store images in MSSQL. The problem I have is that when I retrieve the image from the database and display it in my browser it opens a new window. I would like to use the image control, but it requires a url. Is there anyway of viewing that image in the image control or keeping it in the same page where my information is but displaying it where and when I want it
Can Run MSSQL DB In Linux
I want an answer by tomorrow with examples and reference URLS if we can do this.There is a program written in ASP and the databse is MSSQL (Microsoft) hosted in Windows platform. But they want this databse and ASP Program host on a UNLIX/LINUX server and use the same ASP program. Can thy do it/ and how?
Connect To MSSQL
I had used ASP about a year ago, I had connected to a *.MDB database but not MSSQL,can someone please throw me the just of it
MSSQL Connection
I am using a Windows 2000 Server and when i tried creating a simple asp application this error always appear everytime I access the database. Error Type: Microsoft OLE DB Provider for SQL Server (0x80040E4D) Login failed for user 'MYSERVERIUSR_MYSERVER'. /o/faculty_evaluation/add_dean_db.asp, line 22 what kind of error is this? is there something wrong with my connection string -> conn.Open "Provider=sqloledb;Data Source=MYSERVER;Initial Catalog=dog_evaluation;Integrated Security=SSPI;"
Connect To Mssql
any one have the connection string and included query on how to connect to the mssql server?
Simple Mssql Functions
what are some simple fuctions, like how do i get the date using mssql. also wheres a good tutorial on mssql
MSSQL Date Query
How can I do a query like below on a MSSQL server? The format of the date in the db is 10/9/2004 8:38:01 PM onlinedate = now() strTimeout = 5 StrOnlineTimedout = dateadd("n",-strtimeout*3,onlinedate) StrSql = "DELETE FROM active_users WHERE Last_Seen < " & StrOnlineTimedout &""
MSSQL Date Format
I’m new to MSSQL and I’m having a problem with an ASP3 JS website that I’m upgrading from Access. I’m trying to format the date from mm/dd/yyyy as held in the db by GETDATE to display as dd/mm/yyyy on a web page. Previously with the Access db I used: "SELECT format(addate, 'dd/mm/yyyy') as addate1 FROM...” What do you use with MS-SQL?
ASP+IIS4+MSSQL: Unicode Problem
I need to make an ASP page which needs to insert and display multilingual contents like Korean, Chinese, Japanese from a MSSQL DB. After googling, I know that by the using server-side directive "Session.Codepage=65001" and charset UTF-8 in HTML,I can do it in IIS 5.0. But IIS 4.0 seems doesnt support this Codepage. Is there any solution for IIS 4.0?
MSSQL SERVER 2000 Connections
i just want to ask how many online connections can mssql server 2000 accomodate at the same time? can it handle 250 to 400 simultaneous connections? the specs of my pc is pentium4, 2gb ram, 80gb hd..is this enough?
Extracting Data From MSSQL To Excel
Is it possible to extract data from SQL server to MS Excel ? Say if I have 2 tables (Membership and Profile) and extract some certain datas from those 2 tables; MemberID, Member Name, Birthday, Interest; could it be possible to extract them automatically everyday at 1 AM without me doing it manually? Perhaps its possible to do it with Stored Procedure? or some other means?
Problem With Inserting Date Value Into MSSQL
I'm trying to insert a date value into MSSQL, the type of the sql filed is: "smalldatetime" and i'm trying to insert a text Variable that looks like this: "19/02/2006". .... SET update_date='" & Update_Date & "' ... i get the message: The conversion of char data type to smalldatetime data type resulted in an out-of-range smalldatetime value
ASP Errors Migrating From Access To MSSQL
I'm now receiving this error: Microsoft VBScript runtime error '800a01a8' Object required: '' login.asp, line 9 Worked fine with Access. Can somebody help me tidy up my code. login.asp below. Code:
Compactability Of Mssql With Linux Server
i want to know the possible activities in mssql configured with Linux server. Because i can't able to execute some of the queries in this Configuration. Like, the query is executed in all display the outputs in windows envirnment, but it shows empty data's in linux Environment. ( also i am using the mssql connectivity in PHP) That is Why?
Trapping Mssql Raiserror Statements
I am inserting a record in a table(Trans_Master) using ado recordeset.I have also created trigger on the same table after INSERT where RollBack transaction is done when a condition is not met. the created trigger is working fine.But the problem I am having is How do I can trap thus rollback in asp.One posssile solution I may see is traping raiserror in asp but don't know HOW?
Update/Insert On MSSQL Table Using ASP Forms
I have a problem that it's bothering me for some time now and i will need a lot of help from you. I don't know how easy or difficult it is to be done but i would appreciate any help. I have an mssql 2000 db with table "table1". Attributes for "table1" are: ID (Primary Key) field1 field2 field3 field4 field5 field6 field7 I'm trying through DreamWeaver MX to create a form through ASP and Text Fields, so that i can update "table1" through the form and also on another page to show the results of my table. I have created a form which will be accepting 25 rows, each row having field1, field2, .., field7. I cannot seem to get it to update "table1". Any ideas how this can be done?
Selecting Only Records From Specific Month (ASP & MSSQL)
I am having trouble coming up with the correct SELECT statement to use when I only want to select the records from a certain month. In this case, the current month. In my database all the date records are in this format: MM/DD/YYYY HH:MMAM I figured out what "this" month is by doing the following: thisMonth = split(now, "/") so thisMonth(0) will give me the numerical value for this month. In todays case, its 9. I am then trying to select all records from my database that have their date field starting with the number 9. Here's what I'm trying: "select hitDate from hits where hitDate like '%" & thismonth(0) & "/%/2003%' order by hitDate" But this is not working. It keeps returning 0 results. Anyone know what i'm doing wrong, or better yet, a proper way to do what I'm trying to do?
Good Solution Access MsSQL From ASP [Classic] Use Intranet
I am greeting I would like to consult the better solution(with security consideration) to the access is for MSSQL(2005) from ASP(Classic) in the system of the intranet. a) SQL mixed mode and depositing user name and passwords for MSSQL of the server in "connection string" (with open text) b) Windows Authentication and to send rights to SQL of the server for IUSR_computername c) ? Intranet(server ASP and MSSQL) in the company available from the any computer, workers data (name and pass) they are being kept in MSSQL tables. Problem is because Server MSSQL(Intranet) he will be replacing himself into data with two MSSQL servers and with one PostgreSQL through Windows Authentication.
Verify MSSQL User/Password/Database Combination
I am currently writing a little gadget where users can create, delete, alter... tables in a database. Some kind of MyAspAdmin... Everything works fine as long as I specify the MSSQL-Login-Infos database, user and password. But if I want to make it possible to switch from one database to another, here comes the problem: The user has to choose a database that he wants to work in, and type in user and password. I need the (probably very easy) solution, how i can check if this user/password/chosen_database combination is correct. Code:
How To Set Cookie To Nothing?
The problem is that the code for "change_school.asp" takes the user right to "portal.asp". I checked the code of "change_school.asp" and it does indeed set a cookie value for "school", but for some reason "default.asp" is still finding the old cookie stored and then redirecting...any ideas guys? 'code for change_school.asp...clears the cookie "school" and redirects to page (default.asp) where user can select a new school <% Response.Cookies("school")= "" Response.Redirect "default.asp" %> 'code for default.asp which allows user to select a new school, and if the cookie "school" has some value then they are redirected. <% If request.cookies("school") <> "" then Response.Redirect "portal.asp" end if %>
Cookie And SQL?
On this website i am building it has password protection on certain pages. So i have a "login" portion on the right side of the page, that is shown on every page. When someone logs in is it possible to change that little section to just say Welcome so and so? Instead of having the username and password form with submit button?? Or is this something that requires some java to hide it? Part II When someone logs in i want them to recieve a cookie, in that cookie i want it to contain the person's name (wich i want the to be put next to the "welcome back on part I), email address, and up to four other numerical values. (some people will have greater access to sections of the site depending on who they are) Is is possible to grab this information from the SQL database and put in the cookie? If so can anyone please show me, point me in right direction, ect?
Cookie Value
I'm using FrontPage Database results wizards to retrieve data from Access. I have a cookie containing a number I'd like to insert in a custom query. Whenever the page opens, I want the query to run using the value in the cookie. I haven't been able to figure out how to transfer the cookie value into something the FP webbot will accept in the query.
Cookie
What i am trying to do is this: I want to make a cookie. If someone comes back to a page (say after an hour after they left)i want them to get a specific popup. If someone comes back after than hour I want them to get a different popup, telling them something different.
Cookie Detection
I'm going to go down this route of Cookie detection <% If Request.Querystring("Check") = "" Then Session("cookietest") = "True" Response.Redirect("cookietest.asp?Check=True") Else If Session("cookietest") Then <!-- Execute code if enabled --> Else <!-- Execute code if disabled --> End If End If %> I’m a little worried, do you know how spiders work with regards to this sort of thing? My site gets some traffic due to it being spidered by the likes of google and I don’t want to loose that flow. If I use this at the entry point of my site to redirect browsers with cookies turned off to a page telling them to turn them on will that stop the spiders?
Cookie Availability
If my user turns cookies off, both permanent and temporary cookies can't be used or only permanent cookies can't be saved on the user's machine?
Cookie Not Being Deleted.. How Do I?
I have a cookie with a path of "/" im trieng to delete it before the expired time has comed anyway i am trieng to delete it by setting the cookie to "" like so: Response.Cookies("name") = ""; but its not working but...i found out that if i dont set the path it is being deleted but i have to set the path because from some reason without it i have issues where the cookie is not found in some pages.
A Cookie Disappears, But Not All Of Them
I have a problem with a Cookie in an ASP page. Without any apparent reason, one of the Cookies disappears, but the others are ok. I'm at Page1, a link goes to Page2. Page2 redirects to Page3 and Page3 redirects to Page1. When I'm back to Page1, sometime, one of the cookies don't exist anymore... But the others are there! The disappeared Cookie isn't always the same, in the 18 Cookies that I have. The environment is composed of 4 clustered servers. Page1 is SSL, but not Page2 and Page3. I don't have more than 4KB (1.86KB to be more precise) of data and I don't have more that 20 Cookies on the same domain. I added the following code:
Retrieving Cookie Value
I want to retrieve the value of a cookie to make a form a little more user friendly (our intranet is configured to set a cookie for User First Name, Last Name and Email when they log in) Unfortunately I can't figure out how to retrieve the value of the cookie. I've been trying: <% Response.write Request.Cookies(UserLName) %> But it gives me an error - I used Checky to make sure the cookies are there and they do exist: Name:mascot Value: UserLName=Tarby Can someone give me some advice?
Encoding Cookie.
When I run the ASP page for the first time, I find out, that the Cookie file name contains some several special characters such as %5F, which are encoded with a URLEncode function. So, I have the following string (after convert): ....
How To Remove Cookie?
How can I remove a cookie from the client in ASP? I'm not talking about setting the value to a blank string and I've tried this: [vbs] Response.Cookies("mycookie").Expires = Now() [/vbs] and [vbs] Response.Cookies("mycookie").Expires = Date() - 100 [/vbs] Neither of which work. Is there any way to completley remove the cookie?
Cookie Array
Is there a way to store an array of information in a cookie? ie. a user can have a "x" long list of a variable stored in a cookie, so when they return to the site this information can be retrieved.
Get Cookie Path
Is it possible to get the physical path of a cookie? (C:Document and SettingsmyLoginCookies) Because I need "myLogin" (the Windows Login), and I can't get with request.ServerVariables("logon_user") or ("author_user") or whatever...
|
TRACKER
