Combine Phpbb FetchAll Mod With Asp Page: Convert One Php File To Asp?
I've got a site managed in Frontpage and a forum in phpBB/MySQL. I'd like to grab the most recent posts from the Announcements Forum and embed them in the site's homepage. I got the idea from http://pocketpcthoughts.com/ . All of their homepage posts are fed from their FrontPage Archive Forums.
Right now, I'm using a phpBB mod called FetchAll to do the job. It works great except for one thing: I have to do it via an inline frame because I can't include a PHP file in an ASP page, and I have to use ASP because the site is in Frontpage (project requirement; FP is essential to the non-forum part of the site). Code:
In my pages i have to read a text file which is created in Unix format through my asp code. The problem is that the readline command reads the whole file and not line by line as the file is in Unix format. Is there a way to convert it using asp code and then read it or any other solution to this problem?
As the file is created by an application not controlled by myself it is impossible to force the application developer to do this job so i have to do it during runtime. So what are your suggestions?
How can I convert my web pages into Arabic in such a manner that the value in the text boxes will be in Arabic rather than English. The thing I know is just the code for Arabic is "ar-sa" and nothing more. Code:
I have a Physical path that I need to convert on the FLY I thought using Replace would be a good idea, and it almost works
function MapURL(path)
dim url2 'Convert a physical file path to a URL for hypertext links. url2 = (path) MapURL = Replace(url2, "", "/") MapURL = Replace (url2,"E:","http://myscs/docLibraryDocs") MapURL = Replace (url2, "IntranetLibrary", "")
end function %>
- Is it possible to have multiple replace on the same variable ? - am I doing it the right way ? or is it possible to concatenate those replace in one go ?
Is there a limit on how many Replace one can use for one variable ?
The problem I have is that it takes the first two Replace in consideration but not the third one. If I remove or comment the second one then the First and the third one works fine. For some reason, it doesn't like to have the three in the same time.
by the way, the link I try to change is as follow: Code:
OK - I have a shopping basket with data in a database. Once the person has successfully completed their order I want to be able to send them an email with the products ordered roughly in the following format:
Product Price Quantity
prod1 £6.99 1 prod2 £5.99 2 Postage £0.50
Total whatever..I'm lazy
Formatting would be a little different (just spacing out the prod table a little more.
Any ideas or links to scripts that do this?. I've been looking for a while now but have had no luck in finding a solution. I just want to send a text email (and not html).
The other thing is that on the last page but one, this shopping basket is displayed. Is there anyway I could capture the html data from that page, store it in a session variable and then generate the email after the order has been completed (so sort of like sending a mirror of that page)? In that case having a HTML formatted email would be ok.
I am uploading an excel sheet with .xls extension and want to convert it into .csv file so that it will be easy to read the data which can be inserted in database.
I am trying to display a random background image for a webpage. I found this code to do it
<% 'Defines the number of background images you have Const NUMBER_OF_IMAGES = 2
'Initiates the randomize function Randomize
'Sets a variable: this will be used to hold the 'random generated value Dim intImageNumber
'This is where we create the random number intImageNumber = Int((NUMBER_OF_IMAGES * Rnd) + 1) %>
Modify the body tag to accept the random number. In this case we are going to place it within the image so as to facilitate the selection of a random image. Code:
Right now i have multiple record sets. Im using the following Select statements: How can I combine ClaimNbrSQL, ClaimCovSQL, and ClaimantSQL to pull data based on ClaimdraftSQL.
They have different Where_parts because one field is not accounted for in the innerjoins for the the last 3 selects. Anyone know of a better way of doing this? The problem is the queried table is not matched up correctly. For example if there are 2 rows where dft_mirco_ecd_nbr are blank, the ClamiantSQL is off by 2 rows. Code:
I want to let users select one or more of my 5 choices in checkbox format, but also want to have a choice that is "all 5 choices". When "all 5 choices" is selected, I want to make sure they can't check any of the 5 choices. Is this possible?
May I know how to combine the text that get from textfield with the "strings" and insert it into database? Can anyone help me to check whether example below is correct or not. Any syntax error?
userid= request.form("userid")
emailaddress=userid + "@xxx.com"
insertsql= "insert into database(email) VALUES( '"&emailaddress&"')"
I have this code that will combine month day and year for some reason it puts the data in the database as January9,2005 February, 22,2005 . I need a space after the first month and I cannt figure out where the c
I'd like to combine if possible these two statements drawing from a total of 3 tables.
sql = "SELECT p.Sub_ID, p.Cat_ID, p.Sub_Name, COUNT(c.Sub_ID) as ct FROM Subs p LEFT JOIN Links c ON p.Sub_Id = c.Sub_Id GROUP BY p.Sub_ID, p.Cat_ID, p.Sub_Name ORDER BY p.Sub_Name"
sql = "select * from Subs inner join Cats on Cats.Cat_ID=Subs.Cat_ID ORDER BY Sub_Name"
Is it possible? Am I totaly screwed up for even trying? The goal is to count the relations ships in the Subs and Links table based on Sub_ID, to display needed data from the Subs table, and to display the Cat_name table from the Cats table in relationship to the Cat_ID in both the Cats and Subs Table.
I want to take the contents of many fields of various datatypes (varchars and text) and combine them into a single "junk" field that I will perform SQL Server free text searching upon, e.g.:
tblArticles Title Subtitle ArticleText
CombinedField [Title, Subtitle, and Article text smashed together]
Is it possible to create a query or T-SQL stored proc that would do this? Is SQL Server DTS a better approach? It needs to be built for each row in the table, and it needs to happen regularly.
Is it possible to recall a variable with the combination of text + rs.field? i want to recall the variable "speler1", at the place weher rs("speler") is 1. It's probably again easy.
I have several (three) CSV files each with different columns and dissimilar data. The only common column is transaction date. What I'd like to do is combine the data chronologically. I can't do a join query because the transaction dates do not line up from file to file and no other columns will match either.
I just want all the rows from the three different files put in chronological order in one place understanding that my columns wont line up since the source columns are different. I've exhausted every effort on the SQL side to combine these, but I'm thinking maybe there's a way to do it with FSO or something else.
It works fine but when I use this same code to get x characters plus display it using VBCRLF, with the <br> with writing the code :
<%=Replace LEFT (Recordset1.Fields.Item("Detail").Value,VbCrLf,"<br><br>",50)%>
it gives me error so please can you tell me how can i trim the characaters and at the same time use VBCRLF. why does this above code with LEFT + vbCrLF doesn't work.
I have several text files on my server and I would like to combine them into one text file by just appending each file to the end of the combo file. I know this should be possible, I just don't know how to approach it. Some combination of OpenTextFile and CreateTextFile?
and I'm trying to create a third variable that would strip the first letter of each of the above variables and combine them to create initials. Eg. if FirstName is John and LastName is Doe, the UserInitial variable would be "JD".
I am using asp to submit a form I've created in asp. I was wondering if there was a way to output the vlaues of three listbox menus.
1. User selects hour 2. user selects minute 3. user selects am/pm
This is now outputting into my strBody as seperate entries. I'd like to combine them into one entry within the strBody.
Please reference strStartTime, I've tried to incorporate this into the email strBody, but am unable to accomplish this. Any help would be appreciated. Thanks Everyone!!!
I am trying to post data from an application to a .asp page. What i want to do is to redirect the form post (with all its parameters) to an executable file (.exe) . I am using IIS 6.0 . Is there a way to do this.
I have developed a HTML page containing form and table having some fields, Now What I want is that when I Click on Submit Button then all of the Form Fields should be email to a particular email address just like as they r on the form. So my problem is that i have created an ASP page containing code about to pick data form form fields n send it to email address i mentioned, But i dun know how to request an ASP page in a html page, Iam using
Just after the table creation but it doens;t work because when i click on submit it ask me to save or open MailForm.asp. So is there anyone who can explain me how to run this file directly with in html page or how to use asp code in html page.
