Appending Dynamic Query
I need to dynamically append a session variable to a querystring to every link on our site. Is this possible in ASP?
View RepliesI need to dynamically append a session variable to a querystring to every link on our site. Is this possible in ASP?
View Repliesim trying to create a dynamic sql query based on form user input in ASP. The sql query is then used to filter through a table i have in access. So far i have managed to work with the below code which uses the input from the form and puts it into SQL format.
My form has a field 'PositionTitle1', PositionTitle2' and 'PositionTitle3' all pointing to the one field in my access database. My problem lies in adding functionality for the 'OR' to be used instead of 'AND' in this situation, so that i can place a value in 'PositionTitle1' and 'PositionTitle2' and both will come up in the filtered query.
Any suggestions on how i might be able to alter the below to accomodate for this?
Code:
I'm trying to making a form which can filter the search results. Some of the infomration is in text boxes and other search options are in dropdowns. this is my current query:
Code:
SELECT DefendantCase.VBKey, DefendantCase.PointValue, DefendantCase.CaseNumber, DefendantCase.LastName,
DefendantCase.FirstName, DefendantCase.MiddleName, StatusDescription.[Description] AS Status,
ProsAttyDescription.[Description] AS ADA FROM DefendantCase LEFT JOIN StatusDescription ON
StatusDescription.StatusID=DefendantCase.StatusID LEFT JOIN ProsAttyDescription ON
DefendantCase.ProsAtty=ProsAttyDescription.ProsAtt yID WHERE LastName LIKE '" & lastname & "%' AND FirstName LIKE '" &
firstname & "%' AND DefendantCase.StatusID IN("& statusid &") ORDER BY DefendantCase.LastName, DefendantCase.FirstName
I have 2 databases, one i write two when i submit the form, that works fine. The other holds contact info. I need for when the Company Initials are typed in(form CSN) that the Pace Administrator info fills automatically(PAName and PAPhone). Code:
View Replies View Relatedive been trying this for ages and various ways have all failed! please can some one show me the correct way to achive what i am after!
the ASP code looks like this: PHP Code:
I want to open a text file for appending purpose but it gives me the following error..
Microsoft VBScript runtime error '800a0005'
Invalid procedure call or argument
/cgi-bin/Anagram_Utils/welcome_letter/generatedoc.asp, line 19
Code: ......
I have a database which inputs usernames, passwords, and email addresses into the database. I'm trying to create an asp page that lists the data for a specific user when they are logged in so that they can change details (password, email address etc) any ideas how i can retrieve the data and append the new data to the database???
View Replies View RelatedI need to take a bunch of PDFs that I have made using Appligent's FDFMerge and append them together. I know I could use Appligent's AppendPDF. But I was wondering if there were any free toolkits that I could use with a bit more work out there?
I cannot tell what on the Adobe site would be a candidate for me to even look at. The Acrobat SDK seems to be for Acrobat Reader plugins. Not what I am going for. The PDF library seems a candidate, but what *is* it? A C library? I cannot use a C library unless it has a COM wrapper.
I am trying to run and UPDATE, INSERT and DELETE SQL statements to update append and delete data from some tables in access. Here is the low down:
I want to update All of the fields from a table called TEMP into a table called POSTPONED, WHERE the 'postponed' fields = "False"
I want to then go on and clear the records from TEMP that have the field postponed = "false"
And finally i want to again append the remaining data in the TEMP folder into a table called RESULTS.
Does any one know how to do this or what the SQL statements should look like, i have tried writting them, no luck, i have tried generating them in Access but no luck because the ASP is erroring me on them and i dont know what its chatting about!
I code that creates a calendar for each month and then it displays events from that month that are stored in a db. I need to loop through my recordset and display all the events, but I can't quite figure out how to do it. I am thinking I need to do an array. But I am not really sure.... any ideas. Here is where you can view the calendar. Code:
View Replies View RelatedMy code retrieves a username and a password from a form. Then this information is compared to some usernames and passwords that are stored in a database. The important thing here is that the comparison must be case sensitive meaning that "passWord" is not the same thing as "password"
I have this code, working fine in access 2003
SQL = "SELECT * FROM users WHERE StrComp(username_column,'" & entered_username_in_form & "',0) = 0 AND StrComp(password_column,'" & entered_password_in_form & "',0) = 0"
but get the following error when I run it against my sql 2005 database.
[Microsoft][SQL Native Client][SQL Server]'StrComp' is not a recognized built-in function name.
I don't know the corresponding t-sql for the query.
I am running a querry on an access database and have set the number of records/page displayed at 20. if there are more than 20 records returned, then 1st page will show the first 20, the next page will show next 20 and so on....
The trouble:
the count of total records displayed is correct and the first page is displayed correctly. But when i click on *Next* to go to the next page, all the records of the database get displayed (not the 2nd page of records from the query).
I am using ASP/MS ACCESS to see how I can query the same database, via 2 formfields.
{name: - search}Textfield 1: - Search by Category
AND/OR By
{name: - searchT}Textfield 2: - Location
Currently,
strSearchwords = Trim(Request.QueryString("search")); where "search" is the name of Textfield1
Which is fine, but how can I set it so that on Submit, the string from search, and searchT are somehow joined together into one string?
Ok, I have a Javascript ASP and in it I have a dynamic repeating table with certain attributes to people. If one of these attributes is old or invalid, i want to change the color of the text (and maybe make it flash, blink, change size, something) so that it's easy to read.
View Replies View RelatedIn Access you use "*" + [passed variable] + "*", + can be replaced with &
Calling a parameterized query in Access requires % be used in place of *,
however, all that I have read show dynamic SQL passed to Access:
WHERE [some column] LIKE '" & ASPvar & "' % ORDER BY ...
However, my call is similar to:
conn.qMyLookup strVar, rs
If I modify the query in Access to:
"%" & [passed variable] & "%"
I get all records. If I only put it at the end, as suggested, I only get
matches at the end, not throughout the column. Code:
I want to create textboxes dynamically but with dynamic names also.
i am retrieveing a load of values from a table in SQL into a DataReader.
Then i want to create textboxes from those variables. I want to dim various
textboxes with different names depending on what I retrieve from SQL. I
tried the following:
dim dtrcondet.item("contact_detail_description") as new textbox()
but this does not work
I am trying to create a site that has dynamic page generated based on if a value is present.
PROBLEM
I want to be able to show a certain dynamic page if a certain value equals to true. The page should be able to generate values from a db
e.g. <%=aspscript%>
And if the value equals to false, then the page should not appear at all.
I tried using SSI (Server side inlcudes) but cant append variable names to it or use them with if then statements
I would like to have some text appear in a different color if it matches a result in a database. I am not sure how the syntax would work, this is what I have come up with so far. Not sure how to insert it.
If <%=(Picks.Fields.Item("Pick1").Value)%> = <%=(Results.Fields.Item("Pick1").Value)%> then class="style1"
Is this possible? and if it is does it have to be entered for each occurance of the dynamic text or can it be added to css?
i want o make the images on my website depending on who is logged in. I have all of the Images names stored into my database, which i have uploaded there using the Pure ASP upload 2.09 add on for dreamweaver, and that all works fine and my image is stored in the correct folder and the name of that image is stored into the database as imagename.gif which is exactly what i want, but i dont know how i need to declare that value from the database into my style sheet. Code:
View Replies View RelatedI need to create a bunch of sites with slightly dynamic CSS. Basically,
all the image paths in the CSS need to be dynamic, depending on the
values of certain ASP variables.
I can think of 3 ways to do this:
1. Write a script to create a semi-dynamic CSS file, which will be run
whenever we need to make changes to the ASP variables controlling the
image paths.
2. Have an ASP script generate the CSS on the fly:
<link href="dynamiccss.asp" rel="stylesheet" type="text/css">
3. Put all static CSS in a normal CSS file, and have a special dynamic
style sheet for only those rules that require variability. We could
either use method 2 above to generate a second style sheet, or place
dynamic rules directly in the actual asp pages.
I have a form element and the name is dynamic
name="<%=cnum%>"
i now need to do this but it's telling me that it needs an to be a string.
JobsToUpdate = Split(request.QueryString(cnum),",")
and what would be ideal is the value of Jobstoupdate will be
This Cnum ->cnum=Split(request.QueryString("staticcnum"),",")
Hopefully I explained it well enough.
is there a way to make a dynamic dim, or am i looking at this all wrong
<%
Dim A & request.form("") & B
A & request.form("") & B = Request.form("")
%>
how to dynamically build an XML document with IIS6 and 404 error custom handler?
At the moment if I dinamically create an XML page with Response.Write(xml code here) I cannot remove header "404 errorpagepath" that IIS adds automatically. How to remove that header from Response object?
i think my code is correct.but it still can't work when i run in the nokia mobile browser,i had run my wap gateway and internet service server(ISS) also.
can anyone help me to solve this problem? The attaches file is the wml,asp and database for this program.
i want to have a dynamic navigation that will look at a database and then fill the navigation side. I want to have a category, then a sub- category also. Can this be done?
View Replies View RelatedI would like to build a dynamic link based upon a value returned from a db
There is data in the db because objRS("Description") returns a value.
something like
Code:
if objRS.EOF then
%>
<a href="/somepage.asp?id="<% objRS("Id") %> "><%response.write(objRS("Description"))%></a>
<%
else
end if
I get
http://localhost/somepage.asp?id=
Nothing else at the end.
What am i doing wrong?
it's a dynamic form which should show which option is selected. I've made zillions of these before, and this should work no problem, but there's a bug that I just can't see somewhere... Can anyone see what in god's name I'm missing? Code:
View Replies View RelatedI have been searching for tutorials everywhere on how I could make a menu that is multi levels but that can be updated dynamically through asp...so basically when I add a link in the database it will update the menu...now I know how to pretty much pull links from the database for a basic menu...but lets say there is a link called about us and under about us there is more options to choose from.
How would i code this so the menu would know which ones were parents and which ones where childs? And does anyone know of a good tutorial, or of an example. and basically I want this because I would like to create a content manager...but I don't understand how the menu would work when pulling data from a database.
Is there any way to dynamically generate an include file based on a variable passed to the asp page via a url ?- so for example:
Person x clicks on a url - that ur directs them to template.asp (template.asp has no code in it other than page title etc and <!--#include file="<%variable%>" --> )
Once in template.asp the page loads the include file that is relevant to the companies website that the link was clicked from.
In that include file will be the correct form and stylesheet setting for that company.
What we are trying to do is achieve a global template file which multiple customers can direct peo[ple through and all the data is therefore stored in one central repository.
The file displayed when they reach template.asp will depend on the url they clicked. Basically how can i get the url to pass the variable which the include file will then load??
I have a table in ASP page which displays records and it has a checkbox whose name is ChkBox<%= intRecID %>
<%= intRecID %> is the ID of that record. Now how should I chck whether check box is not checked.
I am having to make sites accessible where images are dynamically generated.
'Display the graphical hit count
Response.Write("<img src=""counter_images/")
Response.Write(Mid(lngVisitorNumber, intWriteDigitLoopCount, 1) & ".gif""")
Response.Write("alt=""" & Mid(lngVisitorNumber, intWriteDigitLoopCount, 1) & """>")
How do I include the width and height attributes in this code?
I currently have a form with 5 rows of textboxes (one textbox on each row). I would like when user keyed in something in the last textbox (textbox at 5th row), it will automatically create another row of texbox below it. Can someone please advise me on how I can do that?
View Replies View RelatedFor some of my pages I currently have part of the URL as being 'ourservices.asp?ID=1' (its got nothing to do with sessions) and I am currently changing part of it so its more SE-friendly - i.e. 'ourservices.asp?services=website-marketing'. However following Googles guidlines regarding dynamic URL's,. it says that some search engines don't crawl pages which have a '?' in them for fear of them being a session URL (which mine isn't).
My question is- is there any alternative that I can use to replace the '?' with another character for my dynamic URL. Or, is this the only way I can have this dynamic URL?