we would like to be able to put a simple query field on a webpage whereby users could enter keywords and then have some of the msx 5.5 public folders searched and return a list of those emails that match the criteria. would anyone know how that might be done useing asp and mapi?
Would anyone have a way to access certain Exchange public folders that contain news group emails, perform a query on the folders for keywords and return a list of those emails?
Basically, I've been asked to put a simple single field on a web page that will query a list of exchange public folders and return a list of those emails that have a key word match.
sort of like the MS Index server does on folders with files where one has an asp interface to query the index data base.
Can someone point me to an ASP application that interfaces to a Usenet newsgroup?
FOR EXAMPLE, I'd like an application that would display the posts here in microsoft.public.inetserver.general, on a webpage in a forum format (I wouldn't use an actual Microsoft webpage, it's just an example).
Does anyone know of any ASP-based newsgroup reader (probably based upon ASPNNTP)? I'm looking for a full-featured reader that I can host, similar to Google Groups.
Can I create a Function or Sub in my GLOBAL.ASA file for all pages of my application to use? If not, how does one do this? For example, I have an "IIF" function since it isn't natively implemented in ASP. Currently I have an Include directive on every page that includes the scripting for this function. I'd rather just declare it once, globally.
'--- Provide IIF functionality to ASP ------------------------------- Function IIF(eval, trueVal, falseVal) if (eval) then IIF=trueVal else IIF=falseVal end if End Function
I have a VB script Sub() that is used by several ASP pages. How do I make it globally available rather than having to replicate the source code in each ASP page that uses it?
I'm creating a web application for my company now. This application has 2 parts. 1 part for the customers to access. The 2nd part is for our staff to access only. My director hopes to make the 2nd part to be something like an intranet, such that only our company's computers (maybe only 1 or 2 in the company) can login to this part of the application.
1. My company's intending to put the application on shared server with a web host. Windows Authentication is NOT allowed.
2. My company doesn't have a static IP address.
3. My manager suggested using Network Card number (which I don't really quite understand. Is there a way to get the Network Card number that's on a client PC?).
How??
Some ISP told us that they can provide a firewall management feature such that it will restrict access to the website from anyone that is not coming from my company's network. This requires Static IP.
Another told me that IIS Manager has the security feature that restrict access based on IP address. This requires Static IP again.
Is it possible to implement the 2nd part (the part that is to be accessed by my company's PC) as a windows application instead? Then we only put the windows application on one computer. So, 1st part (for the public) will be a web application, 2nd part (for my company) is a windows application, both accessing the same database server from an ISP. Will the ISP allow the windows application to access its database server? I've no experience in making a windows application at all, is it the same as making a web application?
I am trying to take all the messages that are in a public message folder and export them to a database and then from there I can output to a webpage. I have it set up so I can do it all manually.I have to copy them all to a persoanl folder and from there I can export to a database.
I am looking for a way to automatically. Is it going to be possible to do, or will I need to take a look at making a Macro to do it? I havent done any real VB in quite some time, just VBScript in ASP's. I am trying to avoid doing the macro thing.
I am going to construct a housing search website ... similar to www.mls.ca ... is there anyway I can populate the data(s) stores in their database? So when my user search for one kind of house, my website will return the data from the MLS database? Or there is similar way to get data from public websites?
Also, if a user search "sport" in my search text box, it will returns all the related links ... just like those search engine ... how can I acheive that? Or I need to pay or register to get the function?
Is there a way to display a calendar created in a public folder? We are using Exchange 2003 and have an intranet and I would like to pull the daily view form the calendar and display it at the bottom of my daily announcements page.
I created an ordering system using DMWMX 2004, and Access DB. On one page I have an insert form and below a display table that shows their orders and calculates dynamically the value of those orders.
As is right now, the display table show orders for 7 days, but It doesn't discriminate what 7 days. I want to be able to display only orders from monday to Sunday until 5pm.
Each table contains the fields: ID(autonumber),Title, Artist, Description, DiscNo, and TrackNo. The second of the two contains an additional field: Price.
How would I make an asp page in which a person enters DiscNo and Price into a form and the code would read all the fields of that record from table1 and then add those and the Price into table2?
I have a recordset that pulls a list of products that a customer has purchased within the past year to date.
Now I need to sum up the total quantity by month that the customer purchased during that time period and dump all of that info into an html table. I am wondering if it's possible to query the first recordset instead of creating a new nested recordset.
Given if tables A and B are in the same database, writing a query for them is relatively easy. But what if tables A and B are in different databases? Is it possible to query them together? If so, can anyone provide a generic example?
I'm having trouble retrieving one field from a table. Bascially i have two asp pages. On one u select a company field this then loads another page that finds the company details and posts it back to the first page etc.
Problem: The address field has line returns in it. When there aren't line returns it works perfectly otherwise it comes back with 'unterminated string error'.
In query analyzer my query works and i can use replace or update statements to remove them in query analyzer however when i try that in an asp page it doesn't work.
I'm building a path making tool, that is i have a network of paths for a park and each section of the path is its own image.
What i need to do is, when a certain piece of the path is clicked, it querys my path database and returns the information for that section of the path to a table.
Im designing in ASP VBscript and database is connected n all but im a beginner, is it feasable?
As well as this i need to be able to add to the table each time a piece of path is clicked, and also take away, like a stack.
AND aswell as this i need a seperate table which adds up the length of all the paths selected (length is in the database).
just wondering if this is possible. i have a page where option boxes are dynamically generated. each time they change the form is submitted, so that it can populate another option box.
these are both database driven, and i was hoping that i could query the information from the database first and then load that into an array/record source. my next task would be to have that array/record source be passed once the page is submitted so that i can use the information again without re-querying the database. (its an efficiency thing) is that even possible? if not what other options do i have?
I want to query multiple tables (all with exactly the same field names) and then display the records returned in date order.
I've written the SQL to query all the tables (they start with the same name, but end with sequential numbers), but it's returning no records when I know there should be some. Any ideas? Code:
I�ve got 2 recordsets, 1 called �special� and the other called �A55�
Special has a field called �Email_Address��.
A55� also has a field called �Email_Address��.
What I need to do is display all of the records in the recordset �A55� but only the records where the email address field is in the "special" recordset I am using ASP so is the solutions ASP or SQL and how is it done..
I have a small (still) SQL database, which I am trying to query from an ASP page.
The field I am querying is of DATETIME data type, and is populated automatically using the GetDate() function as a default value.
When I try and search on this field, using a date/time in the format dd/mm/yyyy hh:mm:ss as the search criteria, it fails with the following error:
[Microsoft][ODBC SQL Server Driver][SQL Server]The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value.
Can anyone tell me why this is? Surely if I am passing a value in the correct format for the data stored in the field it should work? Or am I missing something.
I have a rather basic question. I have a simple username and password front end that queries a SQL database, I run into problems when one of the user names has a single quote in it (IE: O'brian).
I get the "Microsoft OLE DB Provider for SQL Server error '80040e14' Line 1: Incorrect syntax near 'brian'." error message, any clues on how to display those particular cases? is there anything in particular that should be done to my SQL statement?
Does anyone have any functions to start a connection to the database and to query a database instead of typing it all over.
I am new to asp and i got a few days to learn it to get started on my sch project. I have the php database abstarction class, wondering is there any for asp and how do i go abt using it?
Is there any way to quiry two tables in one select command to limit the number of database connections. One quire displays members from a members list the other quires achievments for each member. i.e.
select name, memberno from memberlist then select * from achievements where member = memberno
currently this is done by a loop which requires lots of connections