Alternative To MS Access?
if there is any alternative software to MS Access for creating .mdb file?
View Replies
ADVERTISEMENT
Alternative Of PHP
I have got the following PHP code which I am trying to convert to
ASP.cant find a replace function for Unset in asp which will discard the variable
if ($categoryid == "all")
{
$sql = "SELECT * FROM products where shopinspection=$shopinspection";
unset($HTTP_POST_VARS['categoryid']);
unset($HTTP_POST_VARS['shopinspection']);
}
else
{
$sql = "SELECT * FROM products where categoryid = $categoryid";
unset($HTTP_POST_VARS['categoryid']);
}
unset($HTTP_POST_VARS['Submit']);
while (list($key, $value) = each($HTTP_POST_VARS))
{
if ($value != "" )
{
$sql = $sql .=" AND $key=$value";
//$sql = $sql .=" AND solesource = $solesource";
//echo "<strong>$value</strong>";
Alternative Querystring - Using / Instead Of ? And &
Is is possible to pass parameters with this URL:
www.mysite.com/article/sports/football
instead of the usual method:
http://www.mysite.com/article.asp?c...tegory=football
And, if I need to add more parameters at a later time, may I then use
something like:
http://www.mysite.com/article/sport...321&language=EN
Also, I am using ASP, not ASP.NET.
Alternative To IIS On XP Home?
i have read a few articles saying that you can run IIS on XP home but it does not look too reliable to me and am not too willing to try, so is there an alternative set-up i can use to test my ASP before uploading?
i say this as all ftp hosts seem to want your code pre-tested before uploading .
Alternative Buttons
Looking for a way to switch between submit buttons. The default will be "start" and when the tech clicks on that, the button will start a timer, which I have already set.
The button then will switch to "stop" and when a tech has completed a job and clicks "stop" the timer will also stop and switch the button back to start.
I know how to track the time for each tech that starts and stops a job. I need a jumpstart on how to switch onclicks for two buttons.
CDONTS Alternative
I would like to set up an ASP page that sends an e-mail, but the server I'm working on doesn't have CDONTS installed for security reasons. I don't have any control over the server. Are there any alternatives to using CDONTS that will work or a better option?
View Replies View RelatedAlternative Of #include
Is there any other way or trick to include an asp file in my ASP file than the classic html #include. In fact my filename (which is to be included) will be coming from database and #include statement doesn't support any kind of variables.
View Replies View RelatedAlternative To TEXTAREA
I know this is not a core .asp issue, but I'll try anyway. I've used the TEXTAREA element for a while, but as you know it's limited when it comes to formating part of the text inside a TEXTAREA.Does anyone have expirience using other text cointainer objects (Java/ActiveX), which is easy to use and easy to read values from when sending a form to a procedure .asp page?
View Replies View RelatedIFrame Alternative
does someone knows what's the alternative of Iframe. Actually I have to use IFrame and it works in IE but NS 4.74 to NS 4.78 doesn't support IFrame.
So, I have to use alternative of IFrame so that my application can work in both IE and NS 4.74 to NS 4.78
WinZip / Other Alternative
I'm using ASP and I need to generate a ZIP file that contains a list of files that I'm pulling from a database. I've determined WinZip's command line parameters so that I can use it, the problem is I'm unsure how to run WinZip on the server.
Set WshShell = Server.CreateObject("WScript.Shell")
WshShell.Run("c:winzip.exe")
Assuming this would work, how do I get the process to terminate upon completion? I can't have 20-30 WinZip applications running on the server, I need it to handle what I send to it and then close. Maybe I'm taking the entirely wrong approach here.
Server.MapPath Alternative?
I have an asp file that gathers info from a form and sends to the database. im now changing the location of the database from the root path. I think that because of this i cannot use Server.MapPath method of sending data.
Coudl someone please help me out and let me know how i would change the code? Im quite new to this as you could probably see. Code:
Alternative For CDONTS.NewMail
Is there an alternative for CDONTS.NewMail for sending email? according to this article , CDONTS.NewMail works only on Windows NT/2000 Operating Systems.
Is there an alternative class that works on Windows XP to send email?
Alternative To Response.redirect
Is there another command in asp that I can use to send users to a different page.
I use response.redirect alot in our site and I suspect it is causing us ranking trouble as it is basically a 302 redirect.
I use it like this.
If user is not logged on > send him/her to the log on page and attach a variable showing where the redirection came from so they can return easily.
Is there another way?
Alternative Table Colours
anyways what id like to do is in my "do while" loop i want to create different background colours so its easier to read with large tables.
I know the code should be something like:
If variaiable isnot true then
bgcolour = blue
Else
bg colour = red
end if
i am, however, not quite sure ont he correct syntax for it?
Select Case Alternative
I would like to know if there is alterntiave to using Select Case?I have over 80 files that a user can select from a drop down list and 'read'. Rather than writing out 80+ lines with INC files, what is the other less code option?
View Replies View RelatedRound Function Alternative
Good:
246/10 = 24.6
round(24.6) = 25
Bad:
246/100 = 2.46
round(2.46) = 2 (I want 3)
If I have a decimal, I want to round up. Always. How do I achieve this in ASP?
Alternative To Session Variables
i am using cookies to save a users login information which is then used again on another page to save data to a database. This works fine on certain clients' machines, but on others there is an error. Am i right in saying that it is because cookies are not enabled on their machines? If so, is there another way i can do this?
View Replies View RelatedAlternative To Personal Web Server?
Is there a free ( has to be free ) web server that can run active
server pages like pws?
Alternative To Response.write
I'm trying to build a contact form using ASP. The form works properly but the code I found has "Response.write "Your email..." which appears on a white page after the form is successfully submitted. Is there a different function I can use that will redirect the use to another .html page (like a "thank you for submitting...") instead? Code:
View Replies View RelatedAlternative To Username:password
Are you suffering from the same problem? In the past, you want to access to a secured page protected by Windows Authentication (e.g. Exchange OWA), you will make such redirection "http://usernameassword@domain/exchange/".
However, because of security and Microsoft's latest patch, it will be no longer working. I wonder what we could do now if we want to do the same.
'StrConv' Alternative (I Want Propper Case!)
In VB there is a command that can be used to convert a string into proper case, e.g...
msgbox StrConv("HELLO", 3)
Would say "Hello". However, there is no such function in ASP (it seems to be one of the few commands that was not exported into VBS....god I miss DoEvents too....used to abuse that command.....lol).
Anyway, do you guys know any methods that can be used to do the same thing? Basically I have a name all in CAPS, and I want it to be converted into Proper case so that it's easier on my visitor's eyes when they see it.
CDONTS Alternative Text Content
I'm using CDONTS and am trying to send an email out which displays in HTML for HTML-enabled clients, and plain text for non-HTML clients. Unfortunately I am using IIS4 so CDOSYS is not available (so I can't use the handy .Textbody or .HTMLBody properties). How would I go about it with CDONTS?
View Replies View RelatedAlternative To <select> For Large Number Of Values?
My users have to select an value from a fixed selection of values. The
obvious choice of control for such a requirement is to use a <select> (i.e.
a combo box).
My problem is that sometimes, these combo boxes will have a *large* number
of values. There could be any number of values in them from 5 to 5 million
(unlikely it would be this large but possible).
Obviously 5 million is far too much to populate a <select> control with.
Does anyone have any suggestion as to how a user could select a value from a
*potentially* very large selection of values (i.e a suitable alternative to
the <select> control)?
Powerful MS HTTP Request Component - Alternative To ServerXMLHTTP!
Having just "discovered" it myself, I thought I'd draw everyone's attention to the fact that the WinHTTP 5.x object (which is used behind the scenes by our good friend the ServerXMLHTTP object) can be used directly in scripts.
This is useful because the ServerXMLHTTP object encapsulates XML-related functionality which is unnecessary for performing most simple HTTP requests, and thus by using the WinHTTP object directly you achieve higher performance, scalability, and reduced memory consumption... AND WinHTTP offers quite a few features that ServerXMLHTTP does not expose - including the ability to specify a proxy (and an exclusion list) from within the script (or to acquire them from Internet Explorer's settings), IPv6 support, and HTTPS/SSL support!
For more information .....
ASP Attempting To Access MS Access 2000 On File Share
I have a Development server that is running Win2k, IIS 5.0, and ASP enabled. I am trying to gain access to an Access 2000 DB located on a file server within my domain. I'm pretty sure I have all the correct permissions set, but I am having problems when trying to access the DB.
The error is similar to:
The Microsoft Jet Database engine cannot open the file '******'. It is already opened exclusively by another user, or you need permission to view its data.
I'm looking for ways to fix this... Microsoft suggests turning off the ability for IIS to sync passwords. Unfortunately, this is not a viable solution for me.
Is it possible to create a new virtual server that is a share to my file server? Put my ASP and MDB file in there and have it work? Anyone have any other ideas?
ASP + Access Question (Determining The Last Id Generated By Access)
I'm working on a site that inserts records into an Access database and Access assigns an auto-incrementing id for the record. How can I quickly figure out what id that was just created? I seem to remember there being a function for this....
View Replies View RelatedAccess A MS Access Database Using ASP But On A Linux Box
I want to move my only window shosted client to linux. The site they have access a Microsoft Access database with the below code but i can't get it to work under Linux.
<code>Dim MM_connPang_STRING
'MM_connPang_STRING = "dsn=pangDSN"
MM_connPang_STRING = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:clientdatabasepangDB.mdb"</code>
MS Access - Table Access Problem
I'm trying to access a table in a MS Access database using ASP but the name of the table is causing me some trouble. The problem is the table name has a space in it eg, "My Table".
If i try and access it using a query "SELECT * FROM My News", it says i cant find table "My". If i remove the space from the name (to MyTable) it works fine. But the trouble is its a customers database and i cant easily rename it because its linked to other tables and db's.
How can i access a table with a space in its name? I've tried "SELECT * FROM My_News" but that doesnt work either.
Access Remote Access Database From ASP
I have an ASP page needs to access a remote MS Access2000 database, I got error "The Microsoft Jet database engine cannot open the file 'F:Collect.mdb'. It is already opened exclusively by another user, or you need permission to view its data. ".
The 'F:' is a mapped drive from remote machine where the access database loactes. If I copy the database back to local box, no problem.
How Many People Can Access The Same Access Database
I'm looking to make an online multiplayer game which will utilize Access Database... basically I require thousands of people writing and reading from the same database... I was wondering if this is possible for that... or is mdb file restricted to 1 person at a time...
If it is limited what would you suggest as the best way to control an interactive online environment? .txt files possibly?
Query Works In Access But Not In Asp->access
What is this all about? Generally I run against SQL Server but now I have to use access. The query I want to run is a simple double join
SELECT tblArtists.*,tblGenres.name AS genreName,tblPages.pageId
FROM (tblArtists
INNER JOIN tblGenres ON tblArtists.genreId = tblGenres.genreId)
LEFT JOIN tblPages ON tblArtists.artistId = tblPages.artistId
ORDER BY surName ASC, firstName ASC
Now If I run this question in access against the database it accurateley returns two posts. BUT When I paste the same query into an asp document and runs it with a fileDSN against the same database it returns nothing!? Is this some kind of joke from Microsoft?
Access An Access Link Table
I have an Access DB which contains couple of link tables. All these tables are from different databases. So each one has it's own database password. Since there is no way to save the password during the DSN creation. Then you need to manually type in the password each first time when open the table.
This causes the problem in ASP code during run a query. Since the table cannot be accessed due to the password protection. Is there any statement than can open a table and meanwhile pass the password in? Does anyone experienced with the similar situation?
Write Access To MS-Access
I generate my codes using a generator. My problem is that I can not write into my Access database. I had gone to tools to allow access permission . still nothing.
View Replies View Related