SQL Statement Through ASP/JScript Popup
I have a kinda off-the-wall question for you. I have a piece of ASP code that is designed to 1) create a sql statement and then 2) launch a javascript new window popup to run the sql.
Well, everything seems to be working fine except for when the sql statement gets called it returns an error:Microsoft OLE DB Providor for SQL Server
Line 1: Incorrect syntax near '<'
/includes/confirmins.asp, line 13
Line 13 is simply the rs.open sql line.
The only issue that may exist is the fact that I'm sending the entire sql statement across in the posted data stream (ie confirmins.asp?sql=INSERT INTO Table (Col1, Col2) VALUES ('CompanyName', 'Company Code')...) I receive that posted data through a sql=request("sql"). When I display that field on my page using a response.write - it looks perfect.
Any ideas as to what might be causing this error? Oh, and yes, I have tried using the db connection on that popup page and it works fine, so I know that isn't the problem.
View Replies
ADVERTISEMENT
I have the following code in which the sessionExpire() is function in JScript. To display a msg box. But fails.
<%
If Session.Contents("Access_Key") = "" Then
sessionExpire();
End If
%>
View Replies
View Related
need to learn ASP for a work project but don't really want to have to learn VBScript. Going forward, I'll also need to use ASP.NET so a book covering that with JScript would be good too.
View Replies
View Related
By VBScript I can use this code:
Response.Write "ABC"
How can I use JScript show "ABC"?
View Replies
View Related
Using JScript. is there a better way to write the following reg exp. or am I doing something right for a change ? Code:
View Replies
View Related
Most of the popup companies that pay you per hit only count it as one per ip adress.
How can i make a system that checks that it has shown the popup to a person...and then goes to the next one?
View Replies
View Related
Quote: Response.write "<a href=verify.asp?Address=" & Add & "&city=" & City & "&state=" & State & "&zip=" & Zip & " target=_new>VerifyAddress</a>"
If Add is "101 ABC STREET " , in popup , Add passes is only 101 and not complete one.
View Replies
View Related
my present asp page opens a popup to display the complete data, but my requirement is to create a login to show only some data in the same popup. my choice was to redirect from the popup that shows all data to a new popup which shows some data (having the first popup not opening at all, clearly to redirect)
Any help how to redirect from popup to popup..?
View Replies
View Related
how do i implement this.I have an event calendar and events are already added into the database.Let's just say that today that is an event.How do I show a popup aying "today's events blah blah blah".This should be shown whenever someone comes into my website.it somehow acts as a reminder.Any ideas?I havent start doing the codes but just wish to get an idea of what to do.
View Replies
View Related
i am having problem in popups.i have an asp page from where a popup opens on clicking a link. the value of a variable is passed from the main page to the popup thru querystring. there are 3 text boxes on the popup one of which shows the value of the said variable. the user has to enter data in the remaining 2 boxes.
what i want is, if the user enters invalid data in those 2 boxes, there should be an alert. on clicking ok the user should be able to see the popup with the value of the variable from the main asp page in the 1st box and 2 textboxes with null values in which he/she has to enter the data again.at the moment what i am getting is, the popup disappears on clicking the ok of the alert.
View Replies
View Related
I have the calendar on my sites startpage. A user can click on a link on the calendar to get a popup box displaying the course details and in the popup is a link to apply for the course.
instead of opening a new window I want the startpage to change to the application form. I have tried all the href tags; _blank, _parent, _main and they dont work.
View Replies
View Related
Would anyone be able to confirm that 'jscript.dll' is a necessary file for an .asp page on IIS 5.0 to use the <script language="JavaScipt" runat="SERVER"code? It looks like the code in this section is not working and being recognized since it keeps giving me:
"Microsoft JScript runtime (0x800A01B0)
File name or class name not found during Automation operation"
and am suspecting that this jscript.dll file is a necessary file that's missing or not installed since my search on the webserver's c drive came up empty.
View Replies
View Related
I'm working on a project and the designer guy uses templates for everything. THis is fine except I have to call a JScript function when the page loads and I have no access to the body tag. Is there a way to call the function as the page loads from a VBScript command?
View Replies
View Related
<%@ Language=JScript %>
<%
print "OK";
%>
But,it's error.My computer was installed IIS
View Replies
View Related
I've started implementing my ASP pages (in JScript) using the Try/Catch error handling.
Mostly it is working very well. It gives a nice custom error page which looks somewhat more professional than the default.
However there seems to be one limitation, the error object thrown to the catch statement doesn't include the line that the error occured on. Is there any way to obtain this information?
View Replies
View Related
How to convert this from vbscript to jscript?
MBRequest("File1").Save
MBRequest is a script component
View Replies
View Related
The eval function in JScript doesn't work according to
spec. Specifically, the function C() on page 73 of the
ECMA-262 spec doesn't return the function object
correctly under IIS 5. Binding the anonymous function to
a variable name and then evaluating that works as a
workaround, e.g.
function C() {
return eval("var x = (function (x) {return x*;}); x");
}
works. However, it should be possible to simply evaluate
a function without binding it to a name using the eval
function, especially since the spec has an explicit
example of this.
View Replies
View Related
I am used to doing this in VBScript. But I am not able to get this to work in JScript.
My code simply tries to add 1 a variable which holds a char and parse into an int. But instead of a value of 2 for an addition for 1+1, I see 11.
sCount = Request.Querystring("Count");
//sCount outputs a value of 1
sNextCount = parseInt(sCount + 1);
Response.Write (sNextCount);
//outputs 11 instead of 2
Is parseInt wrong?
View Replies
View Related
Can someone tell me , how to apply jscript in dreamweaver, as well as the example, because I am trying to run jscript script with an include file ....
View Replies
View Related
According to MSDN: "new variables or types defined in the
eval statement are not visible to the enclosing program."
However, in some cases under IIS 5, this is not the case.
Try the following program:
eval("var z = 12; 5;");
Response.Write(z);
According to the documentation this should be an error;
however, it prints "12".
View Replies
View Related
how can i pass a parameter in javascript by referrence.
View Replies
View Related
Im still working on some <%@ LANGUAGE=JScript %> code ;).What is the same command as VbCrLf in JScript?I just want my HTML to jump one line down.
View Replies
View Related
I generally code ASP in VBScript, where I would do this:Code:
<%
response.redirect("anotherpage.htm")
%>
How do I do this in JScript? I keep getting the error "response is undefined".
View Replies
View Related
i have a jscript that accepts parameters/arguments, how do you loop thru the arguments?
i = 0;
while (!i == oArgs.length ) {
WScript.Echo[oArgs(i)];
i = i + 1;
}
this does not even get inside the loop.
View Replies
View Related
If I have a .ASP page that runs JScript code - is it possible to include an ASP page that runs VBscript?
View Replies
View Related
i have a website that users log on to. On one of the pages is a form. What I want to do is only show a certain part of the form for specific users. The way i want to do this is by using their username as a 'show if' command in dreamweaver. What I currently have is this
<% If Session("MM_Username") = "union" %>
all data to be hidden shown is here
<% End If %>
But this doesnt work for me! Any suggestions on how to show this properly?
View Replies
View Related
At the top of my ASP page I declare <%@ Language=VBScript %> what do I have to write to embed some JScript in that page? Do I have to indicate that the code is intended to execute at the client side (if it is the case)?
View Replies
View Related
Do most people use vbscript or jscript to control their ASP pages? I'm trying to decide which to learn.
View Replies
View Related
i have a page of asp (jscript) but the CAPTCHA code im using is vbscript. Can i use boths languages on my page? obviosuly i cant use two language tags, is there a way around this?
View Replies
View Related
I want to count how many characters there is in a string. In ASP I just use <%=Len(Variabel)%> How do I do this in Jscript? How can I display only a numer of characters from a variabel or a string? In ASP I use <%=Left(Variabel,20)%> How do I do this in Jscript? THe code i use is part vbscript and jscript. translate it to pure JScript.
var dot
if(Len(oEventsList.GetBody()) > 20)
{
dot = "..."
}
Response.Write (Left(oEventsList.GetBody(),20) + dot + "<br><br>");
View Replies
View Related
I need to do some client-side scripting for my Intranet and was wondering if
Jscript or Javascript would be better? Everyone here uses IE 5.0 +, so I
need to make a decision...
View Replies
View Related
I currently thinking of converting from my little knowledge of
VBscript to jScript ASP.
With this in mind I'm looking at my current code to see how it will
convert over to Jscript.
One thing I have spotted that I can't think of a way round is the ADO
recordset.GetRows command.
I have a VBscript class that handles my DB connections so in short I
can do things like
MyArray = clsDB.GetRecordsInArray("Stored Proc Name/SQL", other
params)
and this would return the rows into a 2 dimension array.
Problem is I've read that Jscript only has one dimension. So how is
the "getRows" solved for Jscript.
Also is there any good "Jscript" code learning sites?
View Replies
View Related
I have this string:
/sites/binaer/demo/fil/Winnie-the-Pooh 1024x768.jpg
If I wanted to cut everything before Winnie-the-Pooh 1024x768.jpg, how would
I do this?
In VBScript I could find the first "/" from the back of the sentence, and
cut everything before that, but I'm not shore how to do this in JScript...
The string I want to end up with is Winnie-the-Pooh 1024x768.jpg
Any idea??
View Replies
View Related
