My table has a field called ModelName which could contain 1 of 5 vehicle
models. I want to force the query to order these in a particular order (not
alphabetical, but an order that I have determined ('Range Rover',
'Discovery', Land Rover', 'Jeep', 'Others')
Let's say my current query is:
"SELECT DISTINCT ModelName FROM tblVehicles"
What do I need to tag on the end to order the result as stated?
im using cdosys to send an email from an asp page. is there a way i can insert the current page as the body of the email? i know i can send an HTMLBODY and specify a url.... but that wont work because the page is dynamically generated... so i need to be looking at a page, click a button and have the html of that page inserted as the body.
i want to run some code is a certain condition is met and i can't figure this part out i want if the button is pressed then will run my code else will run my other code but how do i specify this button. if "button" is pressed?
1)How can i work out if a certain user is still online? All the pages the user will be able to view has a "check this password etc etc" so i could work it out that way, but would prefer to try and use sessions 2)Work out when a visitor last visited the site. I would like it so that this is only updated when the user LEAVE the site or CLOSES the browser - so it cant be updated on every page 3)Work out what users are on what pages. Again will probably mean sessions but how?! 4)Work out what pages (threads) the user has looked at. I know both vbulletin and snitz do something with the users last visit (question 2) and the last post...but how does it work
I building a page showing the different times in different parts of the world but if the local time is 08:15:25 and I subtract 10 hours, it displays 0-2:15:25. How can I show it as 22:15:25.
Im looking since the begining of the week about saving the enter(vbcrlf) from the html <textareato my MySql database, it save everything but it just loose everything when saving ot the database, do i need a special component to be able to save the enter and tabs etc. Im sure i was able to do it before and it was easy.
Where [0-9]+ means you need atleast 1 number there, the rest is just a string plus my recordset's variable. I know this syntax would work with the regex I learned at school but I'm not sure how to make it work in ASP.
Does anyone have a snippet to hand where i can create a dynamic dropdown for a credit card page, basically i need to dynamically create a drop-down populated with this year as 2006 and go back 4 years?
if you have a function in an include file, and you copy that function and give it a different name.... and then you change the name in your call.. shouldn't it work just like the old function did?
I m using MSQL and I m trying to create table where the first column is autoincremented, this, however, generates a syntax error. I can t figure out the problem:
Create Table tblAuthor (ID int(11) auto_increment,AuthorName varchar(200), primary key(ID));
Error Message: Line 1: Incorrect syntax near 'auto_increment'.
How can I add a quick drop down menu to an asp page? I've tried to incorporate javascript and I can't seem to make it work. I want it to replace the current navigation on this page.
I want to add a "quick search" functionality in ASP or ASP.NET page. I heard we can use Microsoft Indexing Service to accomplish the task, but not sure how to do it. Is this the correct approach? Code:
i am using the following code to generate a xls file using the content type now when the user opnes the file at his pc it takes long time to open..if the no of records in file is large does the use of html tags has slow down the process of opening in excel. Code:
My 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).
In 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 can't write the sum of a certain colum in a table of a db.
<% sql_Sum_Tax="SELECT SUM(vtax) AS sql_Sum_Tax_RS_Var FROM orderstats WHERE vcompletedate BETWEEN "& startDate &" AND "& endDate & ";" Set sql_Sum_Tax_RS = Server.CreateObject("ADODB.Recordset") sql_Sum_Tax_RS.Open sql_Sum_Tax, conn1 %>
I have an Access database of literature that I want to search using an ASP page using multiple search criteria (author, title, year, discipline,etc). I'm using a form to collect the criteria from the user and then sending it to an ASP page. I'm creating the SQL statement using variables that pick up values passed from the form.
Code:
strSQL = "SELECT * FROM Literature WHERE " & _ "(Author Like '%" & mauthor & "%') AND " & _ "(Title Like '%" & mtitle & "%') AND " & _ "(Journal Like '%" & mjournal & "%') AND "& _ "(ArticleBook Like '%" & mBookOption & "%') AND " & _ "(Year Like '%" & myear & "%') " & _ "ORDER BY Title ASC;"
This would probably work if I used "OR" in my SQL, but I want to be able to use "AND." My problem is that I'm not getting records that have null values in some of these fields.
Ive been working with queries through asp on a mdb file. The biggest problem i have is that when i query a certian column that had embedded hyperlinks in it, the query also returns the value of the hyperlink. Is there any way not to have to remove the hyperlinks in the database and not have them show up on queries? Code:
I am learning ASP from the Wrox Begining E-Commerce book, which uses Visual Basic to create a DLL and it also uses MTS as well. I have been trying to find hosting not realising the problem with registering custom dll's on server and know realise that this isn't the best way to do this. I wanted to know if there was anything i could do to change this. I have read a little bit about the Global.isa file but am not sure about this. Could i just transfer all the code into the global.isa and then use it like this. My website access a sql database and uses a mts pipeline for order processing. I don't have enough experience of ASP to re-write this code and am not sure of what to do. I have tried searching the web but am not really finding any solutions that I understand.
I am trying to have the SQL query select from a table where two conditions exist. The line:
Code:
SQL = "SELECT * FROM CompsIn WHERE Out = -1 "
Works, but I want to have it also select from compsin where UserGroup = Session("UserGroup") Until I connect the login and the CompsOut pages,adding Where UserGroup='CSU836' will work just fine.
and say 4569 belongs to joseph i want to tell what josephs rank is looking at the values his rank is 1 if 124 belongs to justin then his rank is 4 the more the points the higher the rank can someone tell me how my sql query will be