I'm trying to query my database and return partial matches of a book title field...how do i go about doing that? Like if they enter "Gatsby," i want it to return, among any other titles with the word Gatsby in the title, "The Great Gatsby."
View RepliesEnvironement with IIS, SQL server and ASP.I've got a SELECT querie on a asp page witch selects à number of rows within my table. With this results and with a form I open an other asp page who does a UPDATE on my table and returns to my first page.
When my first page opens my SELECT querie gives only the first ten results of this querie. I have to wait for about 5 minutes revising my page until he gives all results. It's so strange, that I don't know where to look! My server IIS, my server SQL or someting with my pages asp...?
I have a function displaySiteMemberName(varSiteMember) that pulls the name of a member from the database. I also have a function displayThreadComments(threadID) which displays a little text and then the members name.
However, I can't get it to display on the same line. I'm assuming that its a problem using the response.write but I don't know how to return a value from a function. Code:
I am trying to search through an access database for tickets createded with in a certin date. I am using the below code.
strdate = DateAdd("d", -2, Now())
sqlstr="SELECT * FROM Incidents WHERE TicketDate BETWEEN #"& Now() &"# AND #"& strdate &"# ;"
I verify the query with response.write and get the following.
SELECT * FROM Incidents WHERE TicketDate BETWEEN #15/07/04 19:19:32# AND #13/07/04 19:19:32# ;
I know there are 100% tickets within this date. Yet my query returns nuthing. Please help i've searched this forum for other peoples code looking for examples but end up with the same result.
What is a faster/better coding practice?
Method 1:
Code:
Sub myFunction(byRef x)
x = x + 1 ' do something with x
End Sub
x = 7
myFunction(x)
response.write x ' shows 8
Method 2:
Code:
Function myFunction(x)
myFunction = x + 1 ' do something with x
End Function
x = 7
response.write myFunction(x) ' shows 8
Also discuss considerations when there are more than one variables that need to be changed.
Is there a way to see if 2 fields are similar.. for instance:Code:
If rsHomeT("TeamName") [IS SIMILAR THING HERE???] (rsHomeT("CustomHomeName")) Then
Response.Write " & CustomHomeName & "
Else
Response.Write " & HomeTeamName & "
End If
I dont want to use LIKE in my sql queries to be able to do this.
Is there another program similar to PWS, for W9X? I have problems with the installation, and I wonder if any company made something similar.
View Replies View RelatedI have learnt how to use some aspects of php. But have got a little stuck on databases. Are there some easy examples to follow from the internet on how to modify databases in asp?
Is asp very similar to php? In the sense that you can achieve the same things with it?
is there an online dictionary that I can use to learn asp? especially one that can be kept and stored offline(I am not on the internet at home)
I have a table with two columns. ftr_sampler is set as varchar(255). I want the script to search for similar keyword in the ftr_sampler.
sample table:
id ftr_sampler
- -----------
1 I like to eat apple.
<% if RS3("ftr_sampler") = "%apple%" Then %>
Id 1 like to eat apple.
<% else %>
Id 1 does not like to eat apple.
<% end if %>
I'm developing with CF 5 and SQL Server 2000. I think they are both
great products. The major draw is their cost. I don't develop stand
alone products because anyone that wants to purchase them must also
purchase CF Server and SQL Server. So I run them as a hosted service.
MySQL is supposed to be free. If you are using this product, how do
you like it? What are you using for a front end?
I'd like to move toward developing software that some one can run on
their own webserver with the only cost being the software purchase.
That means the database and front end software need to be free (MySQL,
PHP, CGI). If the customer doesn't have these, they can download them
for free or small fee. What are some feasible alternatives to CF and
SQL Server?
Is ASP Apache comparable to ASP or ASP.NET? Everything will run on a
Lunix Server to keep cost down.
Where i can get similar script to ( http://www.vrating.com ) in ASP & Access
View Replies View RelatedIs it possible with 'classic' ASP to find out the SERVER_SOFTWARE of a remote server.
I wish to have a form where people can enter their domain name and then have a page that based on the form post determine what type of hosting the domain is using.
the next is my platform
IIS5
windows 2000
asp vbscript
My working area has the next virtual directoy:
testAc (corrective ambient)
testAe (evolutionary ambient)
testA (official ambient)
testBc (corrective ambient)
testBe (evolutionary ambient)
testB (official ambient)
Every virtual directory above mentioned , has the same content with littles differences but not important for cookies or for the structure of my
applications.
When I enter in my application I set up in my cookies my language and my profile informations.
I set up the cookies with an expires date and I set the cookie value with a response.cookies("lid")=VARLINGUA (VARLINGUA is an application variable that I have recorded in global.asa).
There is a problem with cookies when I open more of the above virtual directory at the same time or when I din't have cleaned my cookies in my temp files.
After my debug I have understood that my cookies are recordered correctly in my temp files (testAc , testBc ,testA etc....) and they contains the right content, but when I try to read my cookie with the request.querystring I read the double content of my cookie(In my case I have found 2 info about language and 2 info about my profile).
It is possible for you that I read the correct cookie but there is also another value in memory.
I think that IIS has problems to read cookies in virtual directory with similar names. I have this doubt because renaming my virtual directories with various(not similar for example testAc I have called Actest, testBe I have called Betest etc...) I do not have more problems.
I'm looking for an ASP component that manage USER PROFILE, that works similar to facebook or myspace The features that I would like are: Code:
View Replies View RelatedI'm building a site which runs on 4 templates, each a different colour. I would like to pull in different content into each template using ASP.NET, similar to the php version of index.php?page=content.
I've not programmed in ASP before so am hoping someone can either supply me with a script or point me in the right direction.
Can someone give me an example of how to use a
stored procedure that returns XML data?
I want to call the SP from a VBScript program,
and put the XML into a data island in the generated HTML.
I've created a DLL file that enables you to validate accounts and send emails through the MS Exchange server within the Intranet. This dll can be used from within VB, VBA, VBScript and also ASP VBScript. I'm using it in an ASP page that I've created. The DLL has a "SEND" function that will return a string value containing all the invalid accounts seperated by a semi-colon. A sample of the returning string value would look like, "InvalidAcct1;InvalidAcct2;InvalidAcct3". The DLL works like it is suppose to when used in an ASP, but it will not return the string value. I know the DLL works fine because it returns it when used in a regular VBScript or VB program.Is IIS preventing the string from being returned?
View Replies View RelatedI am using a windows 2000 server with IISLockdown and ISAPI_Rewrite installed on it. I have 2 websites A & B. ASP pages on A are working properly, but when placed one B they return 404 error. All other pages such as txt, html, asp.net work fine on B. Both websites have the same configuration, and use the same ISAPI filters.
A sample cade the is not working is, file name test.asp:
<%@ LANGUAGE="VBSCRIPT" %>
<% response.redirect("http://www.cnn.com")%>
Do you know what needs to be done to fix that?
There are two pages main.asp and phonebook.asp.In the main.asp, there is a textfield, where the phone number will be inserted into it. Next to the textfield, there is an icon that when clicked takes you to the phonebook.asp page.
In the phonebook.asp page, there is a list of the telephone numbers and next to them there is a radiobutton. When one of the radiobuttons is chosen (the telephone number is chosen), the number (value) needs to be inserted in the textfield (main.asp page).How may i do this processing? Preferably i need to use asp together with vbscript or even javascipt.
I am using a windows 2000 server with IISLockdown and ISAPI_Rewrite installed on it. I have 2 websites A & B. ASP pages on A are working properly, but when placed one B they return 404 error. All other pages such as txt, html, asp.net work fine on B. Both websites have the same configuration, and use the same ISAPI filters.
A sample code that is not working is, file name test.asp:
<%@ LANGUAGE="VBSCRIPT" %>
<% response.redirect("URL")%>
Do you know what needs to be done to fix that?
Can someone give me an example of how to use a stored procedure that returns XML data?
I want to call the SP from a VBScript program, and put the XML into a data island in the generated HTML.
I have a MS SQL 7.0 table with a large field (> 500 characters). My select statement embedded in my ASP file in an intranet web interface only returns 255 characters. If I run the select statement in Query Analyzer, I can easily change the "Maximum Characters per Column" setting to return the entire field, but that doesn't help me in my ASP web interface. How do I return the entire field through ASP?
View Replies View RelatedI have a form page a user needs to fill out. I want to be
able to send the user back to the form once it is
submitted and an error in processing occurs, for example
if they have an illigal charcter in the form somewhere.
The whole form wouldn't need to be retyped, just the
field in question.
How can I send the user back to the form they just
submitted to correct an entry?
I am passing a XML to SP, and SP in return send XML back. When I comment out sp_xml_preparedocument (XML reading block) in SP, ASP is taking returning XML as valid, but, if I uncomment input XML reading block, ASP is giving following error: Code:
View Replies View RelatedI tried the following:
Set RS=CN.Execute("INSERT into tableX yada yadayada ; SELECT
SCOPE_IDENTITY()")
Using Profiler, I see the statement go through.
But ASP gives me an error saying RS is not an object.
"Operation is not allowed when the object is closed."
In these lines
if not RS.EOF then
theNewId=RS.Fields(0)
end if
If I run the same query in QueryAnalyzer, I do get a return value.
Am I missing something?
I have a seach function and I need to be able to only return records that begin with numbers.
SELECT * FROM [Tbl_Table] Where name LIKE '0-9%'
I've got a site with PayPal and Google Checkout payment options. The checkout page formats two HTML forms, containing bespoke cart code - one posts to PayPal, the other to Google Checkout.When an order is placed, it needs to be updated back on my site, so that the order is marked as 'paid' in the database. When this is done with PayPal, I just provide a hidden field in the form called 'invoice' containing my id number for that transaction. This is returned in my IPN, and I update the database accordingly. However, I can't find a similar field in Google. Their example code all seems to be in XML and is WAAAAAAAAY more complicated than I need it to be. I just need to send a value with my cart code to Google Checkout, and have that value returned after the transaction has completed.
I've set up Google Callback, and the page is being called and the order is being written to my google log txt file, I just need this to contain my order id number for the transaction so I can just add the logic to update the database based on this id number.
I have a field that is stored in SQL Server in date/time format. On one
page, I only need the date to display. I am able to do this by saying:
DateValue(strLastModified)
However, this returns to me the date in this format:
05/10/2004
Instead, I would like to see:
05/10/04, but I am not sure how to do this.
I have a table that has ticket number displays as a link.When I click on a ticket number it displays no data was return. (" it's not reading the ticket number I choose")Can someone look over my codes and tell me what should be doing! I am a the final part and I lost.
View Replies View RelatedI have written some ASP code that selects some records from a SQL database according to a criteria, if no information is found in the database then it sees there is an End Of File in the object record set and prints the line below:
<%if objRecordset.EOF then Response.Write("No information was found for the record you have entered") %>
My problem is that if no records are found it still tries to print the information that it is looking for and cannot find and thus throws an exception. The code for that is below:
<Table Border="1" BGCOLOR="white">
<% Response.Write "<TR><TD>The date for that record is " & objRecordset("DateTime") & "<br></TD></TR>" %>
I was wondering if anybody could advise me how to return just 100 rows from a database query. In Cold Fusion I'd use the maxrows function, but not sure how to do in ASP (or can I do it in just SQL?). My code is thus :
' Retrieve last 100 records. Query then run through the query building a string
Set objRetrieve = objConn.Execute("SELECT Players_ID, Players_Name, Players_Score FROM Players ORDER BY Players_Score DESC")
I'm back with the same code, which works fine, except for when i ad the block of code that i noted...i get the error message:
ADODB.Field error '800a0bcd'
Either BOF or EOF is True, or the current record has been deleted. Requested operation requires a current record.
/test/testbasket.asp, line 72
which is referring to the strSurvID=adoRSWEBtest4(0)
i know that the query above that is supplying webtest4 with its where check is returning a value. when i take out the noted block of code, the page works fine, and emails all information, including the value that is being checked for in webtest4. Code:
I was under the impression (according to all the tutorials) that a Sub differs from a Function in that it doesn't return a value. Therefore I interpret this as meaning if a function is initialised at the top of a page and called at the bottom the result won't be returned to the place it was called i.e. the bottom of the page.
This clearly isn't right though as both Functions and Subs return a value to where they are call from.I want to display the results of a task in a position on the page that is before the task has been carried out.
Therefore if I create a Sub where I want the result to be displayed I assumed that when I call the Sub it would display the results where I wanted i.e. above the task. This isn't happening?