I have two sites, one is a white label version of another. they both use exactly the same code.
The site that isn't white label works fine. Hover the white label site gives the following error:
Microsoft VBScript runtime error '800a0005'
Invalid procedure call or argument: 'left'
/list.asp, line 234
I've looked at line 234 in list.asp and it is just a SQL expression that doesn't appear to have any problems: Code:
when it writes the varFault option to SQL, there is lots of whitespace written too!I have tried the Trim option but to no joy
<%@LANGUAGE="VBSCRIPT" %>
<%OPTION EXPLICIT
Dim objConn, strSQL, objRS, varName, VarExt, VarFault, varDept, strSQL1, objRS1
Set objConn = Server.Createobject("ADODB.Connection")
objConn.open Application("helpdesk")
varName = Request.Form("name")
varDept = Request.Form("departments")
varFault = Request.Form("txtFault")
strSQL = "INSERT INTO new_calls (Name, Department, Fault) VALUES "
strSQL = strSQL & "( '" & varName & "','" & varDept & "','" & varFault & "')"
strSQL1 = "SELECT * FROM new_calls "
strSQl1 = strSQL1 & "WHERE call_id= '"'
set objRS = objConn.Execute(strSQL)
%>
My site seems to preload everything prior to displaying itself. I get a white screen for a couple of seconds and then, bam!, its all loaded and displayed.The same happens when the user navigates around the site. In between each page there is a white screen and a delay.is there anything I can do to minimise this white screen delay?
View Replies View RelatedSay I have a 'Mc Paul' in the database, what would i need to do if the user searched for 'McPaul' how could i pull that record out of the DB.
View Replies View RelatedThere is a problem which confused me for a long time. I have a web application built by ASP running on IIS, and most time it's OK.
occasionally when IE send request to IIS and then receive HTML from server it will stop with no reason. IE shows a white-screen and then I check the HTML source and find that only partially received. After I press F5 everything is OK again...
Does anyone have an example of how to replace all whitespace at the end of a string?
I'm trying something like:
do while right(str,1) = " "
str = replace(right(str,1)," ","")
loop
response.write("str:" & str)
.... but it is killing off the entire string ...
I was calling another asp page from my main page. The another page contains lot of code and processing But after some time my page has turned white and curosr shows that sytem is still busy. Why this happened ?
View Replies View RelatedHow do you write pure text out from a label? I don't want the <span> tags.
For example:
<script>
Owner_FullName.Text = "Lynn Solomon"
</script>
<html>
<asp:label id='Owner_FullName' runat='server' />
<html>
YEILDS:
<span id="Owner_FullName">Lynn Solomon</span>
I would like it to yield:
Lynn Solomon
A user selects a date from some select boxes on a page, an his selection is shown on a text box, so this content is changed dinamically each time the user changes the date. Can I show this text in a label instead of a text box (or text box without borders) how do I do that?How do I do labels or text boxes without borders?
View Replies View RelatedI need to attach a label to each form element on an html form as I can not use the element names. For instance, my element is
<input name="DT_Ctl">
in the asp I use,
For Each FormElement in Request.Form
mail_body = mail_body & FormElement & ": " & Request.Form(FormElement) & vbCrLf
Next
However this means I would get,
DT_Ctl: 1
in my email.
I need to re-label the element without changing the element name so that I would get something like,
Daytona: 1
I am guessing I could attach some sort of variable to each form element but how do I do that.
I'm about to create an ASP script which will essentially parse SQL
tuples (rows) into a Word file, creating labels, although would need
to use the pre-defined label templates within word.
Can anyone direct me in the right direction?
Does anybody know if the Avery label wizard included in Microsoft Word can be used in an ASP page? Basically I want to be able to set the content type on the ASP page to Application/MSword and fill out mailing labels using records pulled from a SQL Server DB.
I know that mail merge is available, but I need to use the extra logic provided via programming this myself. I was also thinking to just make a table and page the recordset so that each page can just be printed out. That brings me to my next point. If I set the content type to "application/msword" and use HTML is there any way to force a page break?
I got this .aspx page with no access to the source code.(apparently it was lost)
anyways. I have this form with a datagrid that access values from a database.
<TD align="left" width="293"><asp:dropdownlist id="DropDownList16" runat="server" AutoPostBack="True"></asp:dropdownlist></TD>
<TD align="middle" width="127">$<asp:label id="Label32" runat="server">0</asp:label></TD>
If you look at the code above, asp:dropdownlist is a string, but I'm not sure if asp:label is a numeric. Since I don't have the source code, how can I change the numeric value that gets to the asp:label within the aspx page.
lets say i get a number 20, and I want to add 15 to it, how can this be done.
I need to take text from a database, turn it into a barcode from the Web and print to a Zebra Z4M barcode printer. I am stuck at two separate approaches. 1. Use ZPL II (Zebra's proprietary language to command the printer) which is executed at a DOS Prompt with "COPY BarCode.txt LPT1" Is there any way to run that from the web. Also, is there any other method of sending the information in the text file to the printer?
Use some sort of ActiveX object to compile a barcode label image, then use another ActiveX object to remove the Header/Footer and Margins from the IE printout. I have found ActiveX objects that can compile the image, but have not found anything to block out the Header/Footer and Margins.
Is it possible to make the following codes Value = idSpecies but its Label TimberSpecies?
<input name="f1" type="text" id="f13" value="<%=((rsResults.Fields.Item("idSpecies").Value))%>" size="33">
I have a database with the following...
Table Name.....Query1
Field Name......idSpecies..........Auto Number
Field Name......TimberSpecies...Text Field
I wish to convert the message received in the text box to be
replaced by the label with the same message as in the text box, After
upload button is clicked this action should be carried on.
So the data in the text box is stored to the database after the button
is clicked and also the textbox is converted to label with message in the
text box.
I am using a xml parser to retrieve and scan through some HTML from a website so that I can use VBScript operations (Left, Right, Mid, Len etc) to pick out the data that I require from the responsetext.
The code works very well and I am attempting to validate the data that the code finds by comparing it to data in a database. Below is a section of code that extracts race locations from a website. Code:
I am to build a site onto an ASP server. Anyone here used Dreamweaver and is it just a simple matter of opening up a new ASP page in Dreamweaver and build the site like you would normally do with a HTML page and it will handle the ASP coding accordingly and you can just simply upload it onto an ASP server and it will work?
The site I am to build is basically just a standard html website, but my friend wants me to build it for an ASP server so he has asked me to make sure it is an asp site so I am presuming with the extension .asp
If I build it as a html site to begin with, will converting it to asp be hard. Could I just export my pages into asp or is there more to it?
Can a Html website be loaded and working on an asp server or host?
Is it possible to have a site mixed both html and asp, eg. the home page is html and when you click on shopping cart on the home page it goes to a hopping cart page thats .asp or do they all have to have the same extension.
I have to pass form data from my site to another organizations site using POST method... how exactly do I do that? Im familiar with how to do it within a single site/domain, and cant use querystring... I dont know where to begin.
View Replies View RelatedWhenever I do a site that is mostly static but with some semi-dynamic
sections, I've struggled to find a good site search solution without
paying for a hosted search service.
I like the FSO-based search engines, but they fail to pick up on some of
the dynamic part.
I was just creating a Google sitemap and it made me wonder: has anyone
created or seen a script that uses the XML Google sitemap to power a
search engine for your own site?
Seems like if you were keeping it updated for Google, why not use it for
your own site?
Using IIS 5.0 and sometime some asp pages (absolutely
randomly) showing as blank white pages. So far only one
way of fixing it - restart whole server. Restarting IIS,
or specific web server not helping, only whole server.
I enable server side and client side debugging, but no
errors showing up...
In view source pages always look like this:
-----------------------
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0
Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html;
charset=windows-1251"></HEAD>
<BODY></BODY></HTML>
-----------------------
Any idea why it can happened and how to fix?
How can my members log out of my shopping website? I can't seem to figure it out. I'm using a session cart where users can log in before shopping or log in upon checking out products. How do they log out??? I'm using ASP and oracle sql.
View Replies View RelatedI would like to create a site map for my map site which is in ASP. I tried
to use Visio to create a web site map but it fails because my asp home page
requires to authenticate. Is there any other tool to create a sitemap from
username/password protected website?
I want to open a website let say
google.com in my own site.but i want to replace some of its images with my own.
but remember site ( google.com ) will be running in my website everything should be of google but look will be mine.i wanted to do it for my own two websites i just used name of google.com to demonstrate my problem
some code to look through for getting started, i still need to sort out thing like a file to hold all the db stuff so i can call the functions rather than type it every time. cleaning up really .
View Replies View Relatedi have a slight background in HTML and basic web dev. I have been asked to create basically the following, it will be my project over the next couple of months. I basically want to build an e-commerce website that will take all data from a database. It all needs to be dynamic, products added to the database would automatically update in the website, the navigation also needs to be dynamic, it needs to be low maintainence, i aim to have the checkout to save customers details to a seperate database, the payment process would have completed, no payment details would be saved.
What do you think on the above. Does any one have firstly any code they may be able to give me, to help me along the way. it does need to be done on a budget, I will buy code if need be. What is the best program to develop such a website in?
I'm looking to eliminate all lag on my site and I have a couple questions regarding databases. Is it possible to open 2 ADODB connections at once? I want to put my sites boards on a different database than everything else but I want to get user information to update in the main db. How would I go about doing this?
Does closing all the stuff you opened in your ADODB connection make a difference? Does it resuly in the use of more bandwidth and site lag?
i have been asked to create a 'site map' for an ASP / Access DB website which i have just started. Can someone explain to me exactly what a 'site map' is and what it is useful for please?
View Replies View Relatedi've got a local server on another pc (ip address:192.168.1.243) but when I want to connect to ASP site that's on that computer it can't. when type "http://192.168.1.243" in my browser it returns this:
IE says: "impossible to find the page" and Firefox says: "the operation timed out when attempting to contact 192.168.1.243". I know that ASP works, because when we try it on the localhost it works (but that's not my computer so I can't use it).
How create site with webmatrix with MySql ?
View Replies View Relatedi have a simple asp counter in my site, the counter uses a access db & cookies (so every visitor will be counted once).
in the past days the counter has gone wild & count goes from 300 in ordinary days to 1000.
i guess this is because of robots, crawls, worms etc. is there any way i can count only real visitors?
I have a situation where I have a customer with one e-comm site and two domain names. Both domains currently point to the one site but they want different logos and purchase tracking for each domain name as visitors come through. I am not that well versed in using the HTML headers but somewhere I seem to recall a way of using the headers to identify the url/domain and then redirect or setup session variables for handling the rest.
If this is ringing a bell with anyone I could use a pointer to more info on this.
anyone knows a VBScript that acts as a webbrowser? I am
behind a firewall and my local machine is not visible to the internet,
but I have a access to some webspace with asp VBScript. With the right
script I could tunnel pages and sites from my local machine