i have designed a website that is using an asp shopping cart script and has a flash header which i have designed to display different content depending on the query string that gets passed to it in the page url. now my problem is that my script has a lot of pages and there are many ways of going from one page to another as well as link as dynamicall generated.
what i im wondering is if there is away that i can make an asp page directly append a query string to the url when the server generates the page and sends it to the browser.
So basically if say i had a page called home.asp when i opened this page some code in the page would make the page serve as home.asp?page=home&content=logo which would make my flash script display content according to the query string it has received. Code:
Quick query, does anyone know how I would go about appending one table to another dynamically?
For Instance I have Table A which holds office A staff And Table B which holds office B staff.
Both tables have an identical structure but hold different data. I want to be able to view them as one table. This needs to work dynamically as both tables will be updated regularly.
I have an append query in Access that I need to run via ASP. The query is called Query 1 and if I use the execute(“Query1”) command the append query will work.
the append query is session dependent. It needs to get information from an order table to a checkout table but only for the current user. For example if there are multiple users I don’t want it to take everyone’s information that is on the site at the time, just the individual. how to solve this? I need something like:
i have a an apending query on access ,and this query copy the info from one table to another table, and its work preety good on access , but i dont know how can i link with asp so i can i activate it directly throw the asp
i have an access db , and i make an append query which copy records from one table to another, and i want now to make an asp page ,i want the query run when i open it. so anybody have any idea about this code??
and i have a second Q which is similer to this , which is i want to make the same move (copy records from table to trable2) but this time throw asp , (without the appending query)
I'm having a problem dynamically creating an UPDATE query that will write the string value of an existing record set field into a data base.To be more concrete, I can generate a string that looks like this:
UPDATE Person SET Person.name='objRS("oldname")'
but when I try to execute it, the literal objRS("oldname")gets written into the oldname field of the Person table, as opposed to the value 'Betty'. (In a separate write statement, I've already checked that objRS("oldname") prints 'Betty'.)
And if I change it to:
UPDATE Person SET Person.name=objRS("oldname") I get an error saying there is an undefined function 'objRS' in expression. Can anyone help me? If I can get this to work I'll be done with this task.
I have built dynamic HTMLTable. Now I want to attach it directly to the Email Body - it is already built, so why not to use a ready table. However, I cannot find the way of getting plain HTML text out of dynamically built control. I tried to put my table between div and read div.innerHTML then - HTTP exception has been thrown.
Here is the SQL Query string that gives me an error.
mySQL = "SELECT * From tblSuperQ Where (DCR Between '"&DCRF&"' And '"&DCRT&"') And Where (Inductance Between '"&indf&"' And '"&indt&"')"
Can you not combine Wheres together?..
If I use UNION ALL between the two where queries, it returns all the results between DCRF and DCRT, AND all the results between indf and indt. I want it to query only those that have values only in both where queries.
This is a pretty basic question which I've been unable to find an answer for from searching Google - I'm trying to query my msql database to return all news stories where the field "smonth" is equal to January, and "syear" is equal to 2004.
SQL_query = "SELECT * FROM tblpages WHERE smonth=" & Request.QueryString("smonth") & "& syear=" & Request.QueryString("syear") & ""
This returns the error:
Unknown column 'January' in 'where clause'
so it's seeing the value I want to pass and assuming it's the column name, instead of the column name "smonth". The fields in the d/b all exist and are named correctly.
I've obviously made a mistake in my select statement or my query string but I'm not sure what.
I have small problem with query string on Internet explorer 7 since I updated and I saw that problem with other browsers before. My code to search is :
I'm getting a QueryString on a page. From this query string, I need to query a database, get a bunch of file names, attach them to an e-mail and fire it out (no problem). The problem is, I want it to happen when a user clicks a button.
I've been using .NET for so long (this isn't a problem at all in .NET obviously)...that I've forgotten how to handle this. Am I going to need a second page to post an array of the file names to and then handle it there? It just seems awfully redundant to need a second page to handle all of this, but I guess it wouldn't shock me.
I know how to use [field LIKE '%keyword%'] to pull up all records that contains the keyword, but what about not containing the keyword? I've tried NOT LIKE but i get Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another.
I have heard about a piece of software that can be installed on your server convert unfriendly search engine ASP query strings to friendly strings that search engines can read
EG Before www.mysite.com/defualt.asp?productID=98283?etc...
EG After www.mysite.com/product/ID/default.asp
It basically takes the question amarks and weird characters out and replaces them?
Does anyone know where i can get ths peiece of software or what has to be done on my server?
I'm trying to encrypt query strings. For Example... I want this... http://whatever.com/?clientID=5 to be something like this... http://whatever.com/?[encrypted string]
I've seen the 4guysrfromrolla's version. Its fine "but" I don't know if it would be practical in this case. I would need to encrypt many urls on a single page and every link on a displayed page would be pulled from a database. the "rolla" version I came across requires that a text file be created and key written for each encoded string everytime the page is called. This doesn't seem that practical to me because I would be writing files and keys dozens of times everytime the page is called.I've also seen aspEncrypt but they want 250 bucks and I was hoping to avoid this. I also see that .Net has a method for this but I'm only working with classic at this point.
I want to pass a querystring in two files using frameset. I'm using Frameset. I'm using this query string. MY question is this can we pass a single value to (2 different files,) using querystring? Code:
It only show the value of rs.fields("alphabit") in grid1.asp and nothing show in grid2.asp Actually I'm using "FrameSet". I just want to pass this value in two frames(in two files). In short i want to get the value of rs.fields("alphabit"). in 2 Frames.
I am working on a site to provide displaying and navigation of images from several groups and have the following code that changes to displayed gif based on the query string passed in:
Call: <a href="ShowImage.asp?group=01&image=01&max=28">Group 01, Image 04, Max 28</a> Code:
i have designed a website that is using an asp shopping cart script and has a flash header which i have designed to display different content depending on the query string that gets passed to it in the page url. now my problem is that my script has a lot of pages and there are many ways of going from one page to another.
what i im wondering is if ther is away that i can make an asp page directly append a query string to the url when the server generates the page and sends it to the browser.
So basically if say i had a page called home.asp when i opened this page a some code in the page make the page serve as home.asp?page=home&content=logo which would make my flash script display content according to the query string it has received.
I have a search page with 7 different field options to search upon. The user can use any or all options. On the results page I'd like to put at the top of each column and ASC and DESC link to resort the results in the user's choice.
How do I save that original query string to reuse in the sort links? My results could spread across many pages, so I'm guessing that I would have to query the database again for each sort.
I have encrypted query values to pass from page to page.I then decrypt them on the other side.On one such pass I use the value to select all the records that match.
encrypted value: /results.asp?club=!#@(yT5$$
decrypted value: club=Wildcats
The encryption/decryption works great but when I try to select on the decrypted club=Wildcats the select statement pulls the encrypted value club=!#@(yT5$$ and therefore returns empty query results.
fp_sQry="SELECT * FROM Results WHERE (Club = '::Club::') "
How can I pass the decrypted value through the select stmt?
When using the QueryString of the request object the actual values are exposed to the viewer of the site and often user pickup on these values and start changing them . This can lead user to see data that they are not supposed to or even data that may be erroneous.
Is there an easy way to encrypt the querystring values that get displayed on the location bar / other than not using querystring. Can I use java script to disable the status bar, at the bottom of the page to not expose the URL's of various links on a page?
I am using asp.net and have a page that does various Database calls based on the query string the I send in. I am also providing a link to the same page, but with one of the variables in the query string changed. The problem is that the page will not reload when I click it, it simply brings up a page with the exact same information.
I often use a querystring in my ASP pages.for example:
if val > 1 then Response.redirect "val1.asp?val=1&user=UserID End if
Is there a way to encrypt the querystring so anyone trying to mis use the web site will not know what the encryption stands for also when people view the page source they should not be able to see the QueryString value. How best can I handle this . Using hidden values still expose the value in the page source. Does HTMLEncode help any?
This is the snippet I use to achieve the above example, which is fine, when I use this snippet, and make the &""& without space between the quotes, then it returns: -
When you see sites using a file id system such as this:
www.website.com/?id=11515
how are they doing that?
I know its a query string but do they have each and every file include or what not written in or are these files entered into a database/SQL and they have an ID assigned to them that calls certain files?
I am looking for some method to capture, into a variable, the entire URL of an http request and redirect to SSL. For example, if a user opens a browser and typed in
I want to do something which must be very simple. If I open default.asp, it creates my frameset and opens my home page. This is what I want to happen.
However, if I create an URL along the lines of http://www.domain.com/default.asp?r..._page=page2.asp, then I want it to open page2.asp, but still within the frameset.
I have an image gallery in a database and I display one item at random with each refresh. I also have 2 buttons "next" and "previous" to show next or previous items in my recordset. Everything works well except for the fact that once the user has used either "next" or "previous" it leaves my query string in the url bar: index.asp?action=previous therefore, if I click "refresh" it continues to display either the next or previous entries instead of dislaying at random like it should.
How can I clear the query string from the url if the commend comes from the refresh button?
