I am trying to add a feature to our inventory that will pass the current URL to a second site so that I can return to the original site later through a redirect. Basically, it is intended to work like this - you do a search, and are taken to a page where you can view the records.
You click on a record to view it and/or update it, and then you are returned to the original search results. I am having some trouble, and am hoping that someone can help me out.
I am placing the values that I want to keep (original URL, search terms, sort order, page number) into a string, and then using Server.URLEncode to encode it: Code:
we have a database with a lot of products in it. and for some reason one fo the feilds is set up like "<img src="images/something/image.jpg" />". they should be set up without the html but because of the way they are set up theres no way i can use them outside of the root directory.
I need a way to just pull the first 10 characters off the string. which would be the <img src=" part, and then pull off the last 4 characters " />. so that i am just left with images/something/image.jpg.
I can sort of get the first part to work by using Mid(string,10)
but how can i remove the last 4 characters?
in php the function would do the ending characters if you made it a negative number. but Mid(Mid(string,10),-4) doesnt seem to work.
Not a problem with my code, but something I would like to add, (ASP VBScript) at the moment I have a form where a user uploads their details including a document (Doc, PDF, TXT, Docx) The document is uploaded to a folder on the server with the address being stored in the database and I'm tracking the user id through sessions.
What I would like to do after the upload is redirect to a blank page, where some script extracts the data from the document and inserts it into another field on the database associated with the user id, I think this may be called parsing, but I'm at a complete loss, I don't suppose you guys have any ideas on this do you.
in my project, i want a label which shows the current value of all shares in the market whenever the user login to the application.how can i do that.how could i dynamically extract data from the shares website.
Basically I want to be able to take the tempreature, pressure and wind and be able to use them as variables in calculating performance automatically for an aircraft. I've tried using the pull string method but can't work out how to seperate the variables.
I have a website where people can add job vacancies to our database. In the admin section I can delete these vacancies but have trouble with selecting certain dates from the database.
For example if I wanted to delete all the jobs from the database for the 18/12/2003 I would select the date then all the jobs will appear on the screen and I can delete them. But if I select a date such as 06/12/2003 or 11/12/2003 it doesnt display anything from the database when I know there are a couple of hundred in there for those dates.
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?
Since most todays' applications are Online (ASP using COM apps/server back-end), sometimes client-browsers need to download data into their PC.
Scenario: A client-browser (IE, ONLINE.ASP) is doing transaction online.... say Invoicing via an ASP page, then it disconnected (DSL connection failure). At this stage, the user will have to do "manual" writing of item sold and when the connection returns... the user will use the browser again.
Question: Can I download data from the Server to the client-browser using a simple click of "Submit" button? Say I would like to download only itemBarcode, itemDesc and itemPrice from the client.... so that anytime the DSL connection fails, the user will execute instead OFFINE.ASP that uses client side programs.
Option: Is there any other option that I could do to have an "offline" transaction processing?
I am having the following error when submitting dynamic data to an SQL Server database:
String or binary data would be truncated. This is of course happening when longer datafields are being inserted. I've tried changing the data types in the database itself, but that does not solve the problem. Do I need to change the data type of the field before it is submitted to the database?
i have the following update statment that this error is coming from i dont realy understand why it is thorwing the error up becuase when i was testing it i change the letter 'c' to and 'a' so not sure why it would need truncated. what does this error actual mean or what do i look for Code:
Each three digit number in the string represents a unique ID of a file in a database. Following each ID are six digits, all seperated by a "_" . Each file will ALWAYS have six subsequent integers, such as above ID "234" has "_0_8_22_2_0_3_" following it.
What I am trying to figure out is given a string of any length of this specific pattern, how to decarle a multi dimensional array that would hold each ID and its corresponding digits.
To clarify a little further, this is from a shopping cart for a photographer. Each "ID" represents an image, each of the six corresponding numbers for each ID represents a qty for an image print size, ie., 4 4x6's, 5 5x7s, 0 8x10s, 1 16x20, 23 20x30's, 48 wallets. Oh, and the image ID's are not necessarily always going to be 3 digits, they could be of any lenght integer...
I'm using conn as ADODB.Connection object. when I write:
conn.execute "insert into table (binarydata) values ('" & binarydatastringvariable & "')" it returns the error:
Unclosed quotation mark before the character string '(here is some string given)'. How can I insert binary data to a ms sql server 2000 table without using adodb.recordset?
I have this page with photo thumbnails that are clickable. Each photo has corresponding info saved on a database. When the thumbnail is click, im trying to show the data in an asp page called info.asp.
sample: Photo #1 when clicked goes to: info.asp?no=1 Photo #2 when clicked goes to: info.asp?no=2 so on so forth..
the database fields are: no picname date details
I only know how to display ALL info from a database.
But i cant figure out how to display SPECIFIC info triggered by a query string. Example. Photo #1 is clicked. I only want the data that corresponds to Photo 1 to be displayed. How can i do this?
what is the maximum number of characters that a string variable can hold - i initially thought it was 256, but after some testing it seems that it can hold much more than that..
I have an XML file that contains nodes and I'm having no problem extracting the information using ASP. However I can't seem to get the ID number from the deliverrequest node from the example below.
<!DOCTYPE xiamSMS SYSTEM "Message.dtd"> <xiam> <deliverRequest id="10234690"> ''' Need to retrieve this number using ASP <to>test</to> <from>number</from> <content type="text">Test 2</content> </deliverRequest> </xiam>
I'm not a asp expert and only use the built in Dreamweaver stuff, the problem I'm getting is a datatype mismatch due to the fact the sql statement is expecting a text string and not a number string, can anyone have a look at the following code and point me in the right direction in regards of what I need to change so the sql statemnet know to expect a number string: Code:
Is there an ASP way of extracting the height and width of a swf file so that I can specify these dims when adding the whole OBJECT code to the web page?
I want to separate the 1st paragraph (article lead) from the others (article), without having one table for 1st paragraph and a second one for the rest of the text.
we have a site, that has a link to a online PC cart that we are registered with. Trouble is, when the user goes to the other site, we obviously no longer have our interface wrapped around the page.
We can do this with an iframe, but it wont vertically stretch the content (a scroll bar appears). Is there any way in ASP, to call a url, and say, insert that url into a <td></td> on our page?
Is there a way of processing an ASP page and placing the resulting HTML source code into a TEXTAREA on another page?
I have a page that will be generated dynamically from database content. However, I want a form on another page to have access to the compiled source code for use in an electronic newsletter.
Manually I would load the dynamic page, view the source and copy it out. I would then paste it into my form field on the relevant page.
Is there a way of extracting only part of an entry retrieved from a SQL database. For instance, if I have an article of 4000 characters can I extract only the first line of the article and them put a link to the full article after the extracted text.
It is something I have been trying to master and will help me display my retrieved recordset data better.
I'd like to do the above, ideally in javascript but i'm aware of the security restrictions with accessing the DOM of a file not hosted on the same server - however i'm not looking to manipluate anything on the remote site, or handle any events (such as keylogging!). All i want is to have a piece of text on the remote site dupicated on my own site.
I'm happy to receive the html as a whole and split it up to get what i want, but i'm beginning to think the way forward is doing it server-side with asp. Anyone know the best way to do this?
OR am i just being silly and there is a way to copy the contents of a remote page into my own page in javascript, split it up and only display what i need.
(btw im quite happy with the splitting up bit, no help needed there - i just need the blasted text in the first place!)
I have a bunch of html stored in a session variable. It's just a long string of html. I want to parse it to extract certain things out of it. I'm assuming I would use the Left, Mid and Right functions. But don't know exactly how to do it. Plus I need to find the information in the session variable too.
I have an access database and am currenlty using classic asp for most of my coding and am trying to extract sentences from the memo field that contain specific strings, in this case "<b>"
The memo fields contain a lot of data so filtering becomes an issue, so i just want to be able to only display the sentences within the memo field i.e. between "." and "." OR beginning of record and "." OR "." and end of record that contain the string "<b>"
I'm developing an Asp.NET system to take a CSV file uploaded via the web, parse it, and insert the values into an SQL database. My sticking point comes when I try to split() the string returned by readline() on the file.
The following code snippet works for me: tokens = "one,two,three,four".Split(",") for each token in tokens response.write("<td>"+token+"</td>") next
However, if I take the next line in the CSV, read using StreamReader.ReadLine on the PostedFile.InputStream, I receive "Object reference not set to an instance of an object." which I have narrowed down to be my string holding the line. Further investigation reveals that no other string member functions work on my line (.ToCharArray, .ToString, etc).
I suspect that StreamReader.ReadLine is not correctly returning a string, even though Response.Write(line) displays what I would expect .....