I need to process a string to do some data insertion into a database table.
However, this string contains some constant variables (set in the include file) and it depends on the value of intDataCtr as below : Code:
Alright, in regards to my previous post of finding a DB that has all of the latitude/longitudes in a DB, I need to now filter through those based on search criteria. The search criteria available includes: Code:
View Replies View RelatedI'm trying to transfer an intranet app from one server to another. I'm
having a problem with the ADO constants on the destination server.
Our intranet site runs on the server.
In a virtual directory, I have a seperate application that is accessible
from the intranet.
I have the following in the global.asa in the virtual directory:
<!--METADATA TYPE="typelib"
UUID="2A75196C-D9EB-4129-B803-931327F72D5C"
NAME="Microsoft ActiveX Data Objects 2.8 Library"-->
This usually allows me to refer to the ADO constants, e.g.
Set rsLoc = oConn.Execute (sSQL, iAffected, adCmdText)
However, in this case, IIS is complaining... Variable is undefined:
'adCmdText'
This is a new (clean) server, so I'm wondering if there is some kind of
confirguration issue..
I'm relatively new to coding activex and I have a problem. I've written an activex component in c++ and I am now using asp/vb pages to access the object. Is it possible to access constants that I've defined in the activex object? For example, can I do something like the following:
Dim constantValue
Set activeX = CreateObject("MyObject.MyClass.1")
constantValue = activeX.MY_CONSTANT_VALUE
Is it possible that both adUseClient and adLockOptimistic does not really work with ASP ?When I use 3 for both - it does.
View Replies View RelatedI realize that this isn't a VBS newsgroup, but it's the only Microsoft newsgroup I read regularly so I hope that you'll be gentle with me. Where is the constant "vbCrLf" defined? My computer has been searching its hard drive for about three hours, now, looking for a definition and it still hasn't found anything.
The reason I'd like to find vbCrLf is because I wonder what else is in there. Is there a vbTab? vbBackspace?
I've been searching for a complete listing of the CDO constants, but have
come up empty. Where can I find a listing of all the CDO named constants
that can be referenced directly with the CDO metadata typelib, i.e.,
<!--
METADATA
TYPE="typelib"
UUID="CD000000-8B95-11D1-82DB-00C04FB1625D"
NAME="CDO for Windows 2000 Library"
-->
I've been trying to create read-only global variables by creating constants (Const) in my global.asa, but I can't seem to reference them. Sticking them in an include works fine, but it seems more structurally sound to use Application_OnStart. Am I attempting the impossible, and if so, why?
View Replies View RelatedI know the basic 8, how do i find any others besides those 8? do you use hex codes? should also note that i need to be able to match the vbcolor to a hex color.
View Replies View RelatedIs it possible to server.execute a file that has a list of constants and then use those constants? I've tried, but the asp tells me the the variable is undeclared when I try to <%=const_name%>
View Replies View RelatedIn an Oracle 8.1.7. Database there's a package like this:
PACKAGE CONSTANTS
C1 CONSTANT NUMBER := -1;
END PACKAGE;
How do I reach CONSTANTS.C1 from ASP?
I have tried
SELECT CONSTANTS.C1 FROM DUAL;
but it didn't work even when run in the database console.
Can I use server.execute to get constant values ?
View Replies View RelatedI have the following problem.
I'm building a site with a db backbone.
In an "include file" I set a constant like:
Const partners = 22
and on some other page, I want to pass the word partners using the query string.
Meaning: I want to make such a link:
href="mypage.asp?module=partners"
When my page reads the querystring - I want it to be able to understand the value of the constant "partners".
when I read from the db using the following kind of Query, I get a "no value specified for one of more..." Code:
Getting this error:
The name 'squibble' is not permitted in this context. Only constants, expressions, or variables allowed here. Column names are not permitted.
/squibble/incFunc.asp, line 13
when trying the following:
Code: ....
I've created a web application with Visual Interdev and I've added Microsoft
XML, version 4 in project's references. A META tag has been successfully added
in global.asa:
<!--METADATA TYPE="TypeLib" NAME="Microsoft XML, v4.0"
UUID="{F5078F18-C551-11D3-89B9-0000F81FE221}" VERSION="4.0"-->
But when I write the following code in an ASP server-side javascript:
<p>Value: <% = SOMITEM_ELEMENT %></p>
I get a Microsoft VBScript error '800a01f4'. Undefined variable:
'SOMITEM_ELEMENT'
I don't get such an error with ADO constants (even though I didn't include
ADOJS.inc). Can someone tell me what's wrong?
I'm a complete newbie to IIs and ASP (come from the Apache/Cold Fusion
world ). I've created a very simple ASP test page:
<%@ Language=VBScript %>
<% Response.Write "This is a test ASP page." %>
But when I access the page, it just displays the page as text, instead
of processing the ASP. I've looked at a half-dozen Microsoft KB
articles, but still no luck. I'm not getting an error, it's just not
processing.
I m facing a problem in ASP. That is on the production machine when I deploy my product at that time it dosenot perform a particular process. But on my devlopment machine it runs perfectly fine.
The only difference which lies is that on my devlopment machine in security tab of wwwroot/(website) a security permission with the name of VS Devlopers(machineVS Devlopers) exist but on the production machine it dosenot. What could be the possible problem.
Making good old fashioned asp page and need to be able to display the IIS COM+ process id's (i.e. those that show up when attaching to a process in InterDev(in debug/processes dialog box).
Is there a way to get these process id's show up in an asp page? You can tell I'm not to saavy when it comes to working my way around the WindowsAPI.
Just like to know if I am correct and no problems in this scenario:
I have page where the user clicks a button to save some information >>
gets directed to page 2 where a value gets returned from a recordset and the form is inserted automatically upon loading with the value (sequential for the database table) >>
the user then gets redirected to page 3 upon insertion into the database, if I use 'Select Top 1 ......' as a query to retrieve some information on this page am I sure that this is the correct record just inserted even if 2 or more people are saving at the same time?
i have to start a batch process from a dll to transfer
files created by this dll to remote ftp server. I created
a batch file:
ftp -n -v -i -s:D:atchftpcmds.txt ftp-server
and a file containing the ftp commands:
user username password
lcd D:atchmedia
mput *.*
quit
It works pefectly when i start it from the dosbox. But
when i call it from the vb dll implemented in IIS (shell
("D:atch ransfer.bat")), it does not complete the
transfer and hangs after 400-500 (small) files.
I need to select a csv file from my desktop through the "Browse.." button in my ASP page and upload the file and do further interrogation and extract the data to put into a database. What I'm struggling with is more the first parts with getting the file read properly in the second page so I can read and insert the data.The data below
describes the file. Quite a simple format.
Customer ID - Additional values are player IDs
193948294, 293, 294, 296, 290, 292
if it is possible to run a process after page has loaded? reason being is i have an application that uploads a file, then zip's it up. These are 50 megs sometimes, so zipping the file can take some time. It is a two stage process though, a user will upload a file, then fill out some more info, then submit, so while the user is filling out more info, I'd like to start zipping the file. Does anyone know if that is possible? and if so how to do it?
View Replies View Relatedwhen i call for a asp page i c some process still running in the status bar. but when i click on the same link again, i could not find the process. it happens alternatevely.why is this happening? how to prevent?
View Replies View RelatedIt's been a long time since I've needed any help with something, so I'm happy to come back and feel dumb again. I need to learn how to process XML data and generate pages driven from that data. I know the structure of the documents, I just need to grab the data from inside certain XML elements of the XML documents.
Can someone explain this or post a link to a good site? I've tried googling, but everything I find seems to explain how to print back the XML in HTML format.
Got a bit of code, which I want to loop through, unless the current value is "", in which case I need it to skip to the next one, but how do I do it?
Response.Write "<br />" & vbCrLf
For Each strItem In Request.Form
If strItem = "" THEN
'these next two lines, I only want to be processed if the above does
have a value in it
Response.Write "-" & strItem & "-" & vbCrLf
Response.Write "-" & Request.Form(strItem) & "<br />" & vbCrLf
End If
Next
Response.Write "<br />" & vbCrLf
Anybody have idea about Image processing tools available for ASP (like Imagemagick,I dont think ImageMagick will work with ASP).
I want to adjust the images uploaded to my site(ASP) to a particular resolution and do some image resolution changes, like creating thumbnails from originally uploaded images,etc..
I have created 2 tables on my db. one is for customers and one for corporate. this is to distinguish the records so that we wont mix up our clients. i have created a login page for both customer and corporate. however, i think there is something wrong with the login process code which process the login for users to our page. there is an error message:Error Type:
Provider (0x80020005)
Type mismatch.
(see highlight in red) for attached code.i am not sure if its correct but here is the code as attached
<%
Response.Buffer = True
strUserName = Request.Form("User_Name")
strPassword = Request.Form("User_Password")
Dim rs
Dim sqlStr
Dim record_found
record_found = 0
Dim vPath, pPath, ConString
vPath = "xxxxx.mdb" 'use this one if database is in root of cart folder
pPath = Server.MapPath( vPath )
ConString = "PROVIDER=MICROSOFT.JET.OLEDB.4.0;DATA SOURCE=" & pPath & ";" & "JET OLEDB:"
Dim Conn, rsCatalog
Set Conn = Server.CreateObject("ADODB.Connection")
Conn.Open ConString
sqlStr1 = "SELECT * from Customer WHERE User_Name = '" & strUserName & "' AND User_Password = '" & strPassword & "'"
sqlStr2 = "SELECT * from Corporate WHERE User_Name = '" & strUserName & "' AND User_Password = '" & strPassword & "'"
set rs = Server.CreateObject ("ADODB.Recordset")
adOpenStatic = 3
rs.CursorType = adOpenStatic
rs.Open sqlStr1, sqlStr2, conn
If (rs.RecordCount <= 0) Then
Response.Redirect("login.asp?from=no_record")
Else
record_found = 1
Response.Cookies("User_Name") = rs("User_Name")
Response.Cookies("User_Password") = rs("User_Password")
Response.Cookies("Login") = 1
Response.Cookies("View_Cart") = 0
End If
rs.Close
Set rs = Nothing
if record_found = 1 then
if Request.Form("hiddenVal") = "view_cart" then
Response.Redirect("view_cart.asp")
else
Response.Redirect("default.asp")
end if
end if
%>
I have few asp pages, which they get the information from a SQL server, while calling these pages, due to amount of data, sometimes it takes 10-15 seconds for loading the page.During this loading time I want to show the users something like a process bar so that the user is not left out with a blank page.
if anyone can guide me, how to show this process bar before completing the load process.
How to send data through winhttpd and process the data in the target page?
My asp.net code doesn't get executed by IIS. My file is
saved with .aspx extension. When i do a view source, all
the vb code is displayed. This shouldn't be visible if
the server is processing the code. How do i get IIS to
process my vb code is my .aspx files?
I'm developing an intranet application using W2k server and IE5.5 - 6.x
clients. I've got one particular function that calls a stored procedure to
update a number of records, depending on user input. The problem we have
run into is that this procedure can take a few minutes to complete in
certain circumstances, and of course IIS times out.
I've been doing some searching for a solution, but most of the answers I've
found relate to showing a 'Please wait' message while processing the page,
which doesn't help in this situation. The others I've found relate to using
MSMQ, which would probably help, but leads to a load of testing issues that
I'm not prepared to deal with at the moment.
Are there any other 'common' ways to handle this at the ASP level?
I am using Win2k, IIS 5 and vbscript as well as asp.
I want to run an asp page that creates a PDF (using a third party ASPPDF dll) as a background process to free up the main website as it takes about 3-4 minutes to render the PDF.
Any ideas on how to do this or where to look?
I'd like to process HTML documents in an ASP script, i.e. to remove any unwanted
elements and extract desired element and attributes. I know how to do it on
client side within IE using its HTML DOM. But what I'd like is to do it
server-side. Is there a way, for instance, to reuse MSIE technology to retrieve
interfaces like IHTMLElement, IHTMLDOMAttribute, aso, or just built-in features
that would allow me to do the same?