Well i have txt file with abt 1000 Sentence i want that each sentence
appear on my website each time diff sentence on each visit on website
! i have done this:
<%
set Testfile=Server.CreateObject("Scripting.FileSystemObject")
set TfileStream=Testfile.OpenTextFile("C:InetpubwwwrootQuates.txt")
TextFormat=TfileStream.ReadLine
%>
<p align="center"><b>
<font face="Arial" size="2" Color="006699">
<i><align="center">
<%=TextFormat%></i></b>
</font>
But it happends for 1 sentense . i have 196 sentence in my txt file .
i want each diff sentence appear on each visit.
Suppose I have a string of word which I have pulled from my MSSQL database - "Super Fine Quality"
But I don't want to show the entire sentence "Super Fine Quality" in my page. I just want to show the word "Super" only, ie I want to display only the first word of the sentence regardless of it's length.
Without manipulating or doing anything in the MSSQL database, is it possible to remove the words "Fine Quality" and show the first word of the sentence "Super" only with the help of asp code? If yes please let me know how.
I need the sentence that should be written after a database opening to made it writable. Code: ------ conn.open strconn Set ob_rs = Server.CreateObject("ADODB.Recordset") ob_rs.Open "select * from temporal", conn ,adOpenstatic **here**
where it says "**HERE**" it should be a sentence to make the database writable. if it is not, the next...
ob_rs.addnew
would tell me that the write authorization is needed.
I'm trying to grab my form field and convert the first letter of each sentence to a capital letter, and the rest of the sentence lowercase (except for I, A etc..)
I've searched all over the place, and only came across functions that convert the first letter of every word to upper case. Now they call these proper case functions. I was taught in grade school that proper case is the first letter of a sentence is capital, and the rest are lower case. So WHY does everyone call these functions proper case functions??!!?? Ok enough venting.
Anyways if you know where I can find a similar function please help me out. I'm sure I could code this, but I just don't have the time right now, and I'm tired, and the Colts lost.
I want to display a sentence in a textbox (multi line). First split the sentence into different lines based on the “,” found in the sentence, i.e.: if I have a sentence something like:
Str = Expatriate Fasilites, Salary Negotiable, Direct Hire
strSplite = Splite(str,”,”)
And it should look like this in the textbox (multi line)
Expatriate Fasilites Salary Negotiable Direct Hire
If I want to compare time, what is the best approach to go ? Any good example ? DateDiff ( ) ?
Pseudocode ========
submitdate = rs.fields("submissiondate") -submissiondate is a date field in a table.
if time for submitdate < = 8:15am then do something A elseif time for submitdate <= 10:15am then do something B elseif time for submitdate <= 12:15pm then do something C else do something D
anyone know of ways to show the dif btw two tables? if using left join . The LEFT JOIN returns all the rows from the first table even if there are no matches in the second table If there are rows in first table that do not have matches in second table , those rows also will be listed . this is not i want. i WANT to show ONLY the dif btw the two table. or can the sql statement be modified to suit my request ?
but what if i want to download a file from diff server. How can i do that? i have tried using virtual directory which is pointing to diff folder in different server but doesnot work. First is it possible use to download files from virtual directory pointing to diff server altogether?
I understand that all asp classic vars are variants and to always make sure that you are working with the type that you want it is best to use these built-in Cxx() functions, but I'm confused about whether I should use CSng or CDbl for my calcs.
I don't think they will ever be more than say 6 decimal places (at the very most usually 2 or 3) and the value the other way won't be in the millions (chance would be a fine thing!!) so should I be using CSng or CDbl? Is there any kind of performance degradation in using one over the other? Is there any kind of accuracy degradation in using one over the other?
I have one ASP page that has two separate FORMS, each that will update a separate SQL table. These tables are in the same DB with the same connection string for both.
The SQL statement seems to be writing correctly (when I test them) but neither of the tables updates when I try to update both of them. IF I try to update just ONE of the tables it does work correctly. Code:
i have a page that i need to load in an iframe that is on a diff domain (sub domain), i need to get the doc height of the page so that i can adjust the iframes height (so there will be no scroll bars).the problem with that is even though its on the same sever, because it is on a subdomain the browser sees it as different and restricts access to it (makes sense).
so, what we can do is have php read in the page with curl and parse it out in the iframe. that looks like <iframe src="reader.php?page=subdomain.pagename.html">but, we cannot use php on this server so i was wondering if there is an asp solution that can do the same thing (vb script). basically, i just need that asp page to grab the page on the sub domain, read it in and then output it.
I need to execute different asp programs based on different values of a parameter. For example, if the user inputs ID of 1, program1 needs to be executed automatically, if user inputs ID=2, program2 needs to be executed in the background automatically. How do we do this in asp?
I was trying to integrate a forum software to an existing site. The site is having a different database file already. What i want to do is, copy the forum tables from forum database file to the existing site database. How can I copy the tables from FileA to FileB using ASP?
I want to send email with attachment. I have no problem if the file is located on the same server but i got error when attach file from different server. This is the code,
set mail=server.CreateObject("persits.mailsender") mail.host="smtp.mydomain.com" ..... 'mail.addattachment "c:attach est.txt" ' no problem with this mail.addattachment "websvrattach est.txt" ....... mail.send
I got this error, "Persits.MailSender.4 error '800a0007' Logon failure: unknown user name or bad password."
when i changed the servername to static ip address also got the same error. any idea? fyi, this user has an administrator rights to the server.
I am using a Relational database for my site and i have the following tables:
FIXTURES, GAMEDATES
the fields in FIXTURES are:
GameDate Home Away
(All of the above are numerical fields)
the fields in GAMEDATES are:
DateID(integer) GameDate(#Date Field#)
What i have done is in the GAMEDATE field in the FIXTURES table i have used the ID number of the date that i wish to assign to that record - using a LEFT JOIN to display the actual date that is pulled from the GAMEDATES table (That which corresponds to the relevant id used in Fixtures)
The problem is that in some of my code i want to display records using sql and sometimes in the where clause i use the following:
WHERE Fixtures.GameDate<=(Date())
obviously meaning WHERE GAMEDATE is LESS THAN or EQUAL to TODAY.
The thing is when i use the join it does not use the where clause and displays all of the records in the FIXTURES table.
Does any one know how to get around this, i have not received any error messages it just isnt displaying the right data
Im comparing values in a field while doing a loop if sAct<>myData(5,i) then At the end of the loop I make the value of sAct equal the current myData
This will work when comparing other fields withing my recordset (so I know the statement works) but it will not work for the field I want to compare. The only difference with this field is that it has null values. Could this be the problem? if so, how do I deal with nulls?
I have a input form with 5 fields. One of the fields is MajorNo and the other is named Description.
I have a reference table in my MS Access database (tblMajor)that lists the major numbers and their descriptions.
I would like to have the description field in my ASP automatically filled based on the major number entered on the form, so the user will only need to input the major number when submitting to the Access table (tblSalesTotal).
I am trying to pass a hidden field value on a form into another field on the form so that it can then be inserted in the database, to enable me then to reference that number at a later date.
(The hidden value (1 for example) would then automatically get passed to the other input field.)
The code for the text field that allows users to type an number into it for submission to the db is below, but what code do i need within the hidden field to populate this text field below so that users do not have to type the number in? Code:
I have being working with making an edit field over the past few days. The edit function is now working fine. The edit fields that i have are for id, subject, notes, timedate.
All of the edit screens are one line text screens. What I want to do now is increase the size of the notes box to a larger textarea type box to make it easier to edit notes. The notes field in the db is a textarea field. Code:
When you select the "Country" field in a Hotmail "get new account" link, the field "State" changes automatically, giving you the correct States that belongs to the chosen Country.
I would like to capture an entered value and use it in a query (Access)
Part No. __________
Do I need to store it in a variable and then can I have the query come up on the same page - they would enter a value and click a submit button. I'm not sure that I am on the right path. I'm not sure what syntax to use. Code:
Using asp and mysql, can a text field in the db have a record with asp code in it and then display correctly on an asp page?
My experience is that it does not show anything in the <% %> tags but it shows the asp code when you view source. My coworker wants to make our website database driven and this text field was going to be the page content with html and <% if then else %> statements.
This does not work with php either so is there another field type that will parse server side scripting?
Im wondering if there is any way to add a field into an MS access Table using SQL/ASP..
The reason im asking is my database online is Access 2000 (which i have at home), and im in work and they use Access 97.. so i cant download the database, add an extra field into the table, and then re-upload..
Ive tried using a Make Table, Update, Append.. but it doesnt like any of them statements..
