I am trying to insert three variables into my table in my asp program. Can someone please tell me if my syntax us wrong. I keep getting this error:
Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
[Microsoft][ODBC SQL Server Driver][SQL Server]Line 3: Incorrect syntax near '&'.
/credFeesEdit10.asp, line 735
Here is my insert statement: Code:
How to prevent duplicate values when using BULK INSERT to insert CSV to SQL Server? Code:
View Replies View Relatedcan anyone tell me difference between environment variables and server variables.
View Replies View RelatedCan any one tell me what is wrong with this insert statement:
sql = "INSERT INTO Questions (Question,SurveyId,CatId) VALUES ('" & question & "','" & surId & "','" & Sig &"') "
and why when I print it to screen, it shows this:
INSERT INTO Questions (Question,SurveyId,CatId) VALUES 'this si a test','38, 3','');
I have used similar and it works, they are the right values bit wont work..?
Here is my delima im hoping you can help me with. My code currently works fine. However I want to make some modifications to it to get that best possible outcome for my client(Taxi company). Here is the code logic:
The code code currently has one text field which takes a number(Taxi number) and returns all calls assigned to the taxi number inputed in the text field and returns all, canceled, and pickedup calls by said taxi number within the CURRENT DAY. Im trying to find out how i can input a taxi number and get returned calls from PREVIOUS DAYS also preferablly going back one WEEK to a MONTH. I hope im clear. If not please inquire for further clarification.
Heres my actual code:
how to declare session variables and use it in insert and update sql statements... the scenario is I have:
2 html forms
2 ASP FILES
I am able to trap data from the first form into the acces table..but my second form(which is continuation of first form) has a update query....(ie...it shld update the same record the one inserted from the 1st form )..both the forms work on table in access db
its an annonymus...questionnaite...therefore i am not trapping any user name or login id...but the requirement is the survey made shld be unique....as in no user shld be able to answer the questions twice.
I'm having a problem with passing variables inserting to my database. Here's what I'm doing. I have a page where the user selects a team member (this is fine) Once the team member is selected I have the variables on the form send and email to all supervisors and the member selected (this is fine also) BUT, I'm having problems inserting the emailed information to my access 2000 database after is email. Can someone guide me in the right direction.
View Replies View RelatedI hae a date column "datetime" 8 i want to insert the date and time via my insert statement is Now() suitable for this?
I tried it and it worked but i'm hesitant that it might not work correctly or i'm using the wrong syntax.
I need to know how can i insert the data that is saved in an excel file into my SQL Server database.. I've seen some websites.. but i dun quite understand them. I would be great of you can explain to me the steps in doing tat etc...
View Replies View RelatedWhat do you need to have on the server in order for LOGON_USER to work?Its not working on my server.Reverse DNS maybe?
View Replies View RelatedNeed to know some about current user of NT domain. In my asp page i have used Request.ServerVariables("LOGON_USER") to get current NT user but some times it returns nothing and some times it gives correct user name.
In my application i am redirecting from one page to antoher and i need to keep server variable "LOGON_USER". For every page i have different kind of security. I don't know wheather i am missing some thing at IIS or this command works unusually.
I just have a question for something I have been seeing out in the WWW.
Some websites that I goto display the city and state of where I live. The question is How are they doing that? is it a Server Variable ? If so does any one know what that Variable is?
My website is currently made up of HTML pages and residing on a Windows server.
Currently converting them all to ASP, that is going from .html extensions to .asp (besides adding funking asp functions)
My pages have all being indexed by Google, so wouldn't risk loosing good ranking with Javascript redirects, so I tought using this would solve the issue, for example, on a file named thatpage.html
<SCRIPT LANGUAGE="VBSCRIPT" runat="server">
Response.Status="301 Moved Permanently"
Response.AddHeader "Location", "http://www.mywebsite.com/thatpage.asp"
</SCRIPT>
Wherever where I insert it, in the head, in the body, before the DOC, it's not working, will have to resort to javascript? Will I have to put a link in the html page leading to the asp page? Wouldn't like to have user click agin to be led to the .asp version?
I allow my users to upload a picture from their machine to my website on the server. I know the exact name and the path of the uploaded picture in my server, is something like:
D:hostingmysitedbgraphicspicturename.gif
Then, I would like to insert this picture into my home page. How can I do that without manually download the picture from server to my machine? How can I insert a picture that exist in my server into my page?
I try to make my page http://tudef.jezz.dk show the online users ip numbers, but i only get my own ip, even if more users are online.
I use request.server.variables and remote_addr
Is there any way to deny a server variable to be run on a server such as LOCAL_ADDR?
View Replies View RelatedI cannot view Server Variables Specifically HTTP_REFERER, in an ASP Page that I access either by a From POST from anothe rpage or a link.
View Replies View RelatedI'm working on a shopping cart page. In page A (checkout) the user
enters their credit card information. On postback, if everything is
correct, it sends the user to page B (confirmation). My question is,
can I (or should I) use server variables to send CC information to page
B?
My boss doesn't want me to store this information in the SQL
database we're using. Obviously cookies are out of the question and so
is passing info through request.querystring, so I was thinking on using
session variables for this, but not sure if it's safe.
What should I do?
I am trying to grab the server name and IP address using Response.Write (Request.ServerVariables("ALL_HTTP"). I am using this one because I wanted to see everything that is brought back.
The server name I am getting back seems to be the host name found in IIS not the fullly qualified domain name of the server. Is there a way to get the fully qualified domain name of the server?
Also this server is one of two servers in a cluster and the IP address being returned is the IP address of the cluster server. Is there a way to get the IP address of the server that I am actually logged into?
At the moment I am building a small news board on my companys intranet. There are 2 different offices with 2 different domains. for each office I want to show different news relating to that office.
Is there any way with asp to get the name of the domain that the user is logged onto so I can filter different news for each domain. This will just save the hassle of putting the intranet on 2 different domains.
I have built a site that works/worked absolutely fine on my test server. When I transferred it to a remote web host (the intended permanent home of the site) something very worrying keeps happening to my site.
I use, as is the norm, session variables to store login information. At the top of each page I do a check that Session("isLoggedIn") = "True", and if not then the system logs them back out.
The serious problem is that once you have logged into the site, the next page you try to open it fails the above check and logs you out! Obviously Session("isLoggedIn") is not equal to "True" so it assumes you aren't logged in. So basically the session variables are getting lost/cleared. This makes my site unusable, and is a disaster for it unless I can get a solution.
Does ASP have a function to list all the server variable similar to PHP's phpinfo()?
View Replies View Related<%
response.write(Request.ServerVariables("REMOTE_USER"))
%>
When i use this it also gives me the domain name as well as the username. (example, amrswbouse) I know i can do js to trim off the first few letters but i want to know if there is a server variable that will save me the effort.
isit possible to access variables (code) from ASP server script to ASP client page?? take for example the code supplied below:
'server script
<%@ Language=VBScript %>
<%
dim svalue
svalue="access me"
%>
'client code
<HTML>
<BODY>
<SCRIPT LANGUAGE="VBScript">
dim x
x = svalue 'svalue isfrom server script
response.write x
</SCRIPT>
</BODY>
</HTML>
I want to be able to client process of the ASP page to get the value
populated in Request("rssFeed"), how can I do this because the Request
object is not available to the Client-side.
I have a very odd situation here. I have an administration page, where based on a users permissions, a recordset is called from the SQL server which has a list of paths to "Module Menus". Each of these menus are then placed into the page by calling Server.Execute(rs_Modules("ModulePath")).
This works fine for up to 15 "menus" After that, the session variables that were set (not including those called by Global.ASA) are no longer set. Code:
Just as the title says I am trying to do something impossible with a single SQL statement. I am doing an ASP webpage for internal use at the company I work for.
I want to know if there is a way to insert/update data into multiple tables in 1 SQL statement.
If it requires functions | views or anything else that is fine but I don't want to have 3-4 different SQL statements to update 2-3 different columns in different tables.
Request.ServerVariables("path_info")
I am able to get the full path, i.e
/community/default.asp
However is there a way that i can get the querystring as well on top of that.
for example if i am on:
/community/default.asp?pageid=3
This is my problem with a lot of my funcationailty, if you click a submit button, then it does not action, but sends it back to default.asp
/community/default.asp
- I have a page with two radio boxes with values of "agree" and
"not_agree".
- The form is set to GET which goes to the below script for
processing.
- No matter which of the two radio boxes are selected, it always goes
to the page "/broadband/order.asp".
- There is no other code on the form processing page apart form what
is below. Code:
I'm not sure how to best describe my problem, so a simple example should help explain things:
I have two arrays, called set1_data and set2_data
if I create a variable like so:
firstPart = "set1"
and then assign like this:
copyOfArray = firstPart & "_data"
how do I make copyOfArray reference the set1_array, as opposed to just a string "set1_array" which is what it's doing?
I've had a good rummage round ye olde Internet but couldn't find anything there must be a keyword or function to achieve this?!?
I have sql server express at my PC-windows xp professional, I try to connect to a table via asp (queryString :"Driver={SQL Server};" &"Server=localhost;" & _
"Database=local;" & "Uid=nikos;" & "Pwd=nikos;" but there is an error
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC SQL Server Driver][DBNETLIB]"The SQL server does not exist or there is no permission.
I can login with EMS lite both with sql server Auth. and windows auth.What is fault?
I'm trying to install a simple e-mail form to my webpage; which takes some info from user (like name, phone, e-mail,etc...) and when user pushes submit button e-mails them to me immediately. I've tried to do so with ASP Formmail but I couldn't succeed. . it gives me: Server object error " 'ASP 0177 : 800401f3' Server.CreateObject Failed " error. Can anyone please help me to install my form? Because I need to install it immediately;
View Replies View RelatedI'm getting the error,
Server object error 'ASP 0177 : 800401f3'
Server.CreateObject Failed
/pdf_project/form1.asp, line 19
Invalid class string
I'm trying to submit the data in my pdf form to the web server.I've written the .asp code for it but it has been giving me this error.