Thread 21 of 21 | Thread Starter | | |  charbrad | Need help with subtotals{Too Long!} 5 replies. Last post: |  charbrad | My post is there more than once because I was getting a thread error each time I hit save reply...sorry |
|
 14893 Hits | |
Thread 20 of 21 | Thread Starter | | |  ParaDelphi | Exit a While LoopI've been looking all over, how do you exit a while loop? I tried exit and that didn't work.
5 replies. Last post: |  Paul.S | Thanks to both of you. Great help as usual. I did get it from Mike's post but the example is nice especially for others looking on. |
|
 11533 Hits | |
Thread 19 of 21 | Thread Starter | | |  aka51 | Error evaluating CHECK constraint{Too Long!} 4 replies. Last post: |  jdschram | one other thought is that the constraint is actually on a field...like you have a field that cannot be null in the table you are trying to insert into...best bet is still to response.write your variable and work on it in access alone...that way you can be 100% sure it is not the DB that is causing the problem |
|
 8305 Hits | |
Thread 18 of 21 | Thread Starter | | |  Me | Help with some code{Too Long!} 6 replies. Last post: |  Me | I know, I've fixed it |
|
 7763 Hits | |
Thread 17 of 21 | Thread Starter | | |  ASPGuy | Creating Classes in ASPDoes anyone have a simple example of creating a class in ASP? I've always used it as a scripting language and never used in in an object oriented way.
|
 6662 Hits | |
Thread 16 of 21 | Thread Starter | | |  deleted_member | Data Environment ProblemI've got a problem that involves using the Data Environment with an interdev, application. We've deployed an interdev application to the IIS server., When we attempt to run the asp page we get the following error, , Server object error 'ASP 0177 : 800401f3', , Server.CreateObject Failed, , /db/global.asa, line 46, , Invalid class string, , , line 46 is Set DE = Server.CreateObject("DERuntime.DERuntime"), , I wasn't able to find this class on the server, and I assume that this has, to do with the installation of IIS and the deployment of the application., I've been out to Microsoft's website and haven't found anything that really, seems to relate to my problem. Do you lhave any insights? My current, thought is that the data environment runtime is not installed or maybe not, registered correctly. If that is the case how does one get that registered, / installed. We have ado25 installed. |
 5187 Hits | |
Thread 15 of 21 | Thread Starter | | |  bphilip | Kill a windows Process Using AspI need to create an asp page which will kill process in a windows 2000. Please help 1 Reply: |  mprestwood | I don't think this is possible at least not with ONLY ASP and in a real webserver environment because you would have to grant unusual rights and make use of something like a DLL with special rights.
|
|
 4374 Hits | |
Thread 14 of 21 | Thread Starter | | |  Johnc | ftp/asp headache...I wrote an ASP program that utilizes an FTP download feature, grabbing files that are stored in a paradox database and places them wherever the user wants on their hard drive. My question and problem is that our Users that download the files from our NT server have no problems opeing the files when download, however our users that grab files from our windows2000 server cannot open the files until the Web Server(Windows NT where i installed IIS and host the website) is reset, apparently the files get locked up, Paradox assumes the users are opening the files from its current location, but they are just grabbing a copy of the files from my website and storing the file on their hard drives...any ideas why this locks up only on the windows 2000 server...thanks 3 replies. Last post: |  Johnc | {Too Long!} |
|
 3859 Hits | |
Thread 13 of 21 | Thread Starter | | |  aka51 | Help with a loopthe code below for some odd reason will not work. The values for the session variables are being assigned when a database is queried. but for some reason if the session variable is empty it goes onto the else portion of the statement, , , , if Session ("aoemail1") = "" then , strTo = strTo &"here", else , strTo= strTo & Session ("aoemail1"), strTo= strTo & ";", end if , , , if Session ("aoemail2") = "" then , strTo = strTo &"here", else , strTo= strTo & Session ("aoemail2"), strTo= strTo & ";", end if , , , if Session ("supemail2") = "" then , strTo = strTo &"here", else , strTo= strTo & Session ("supemail1") , strTo= strTo & ";", end if , , , if Session ("supemail2") = "" then , strTo = strTo &"here", else , strTo= strTo & Session ("supemail2") , end if
1 Reply: |  cheddar | post the code that set's the values and the loop. |
|
 3831 Hits | |
Thread 12 of 21 | Thread Starter | | |  aka51 | ASP queryI am submitting a query in an ASP page. , , It is a tow piece query and I am not sure the correct process to accomplish this., First I am , , , SQL ="SELECT OAID1 FROM tblOrganization where branch_labid = "& Request("branch_labid") &";",
then the valuse returned from this query i would like to use it in the next query , , , SQL ="SELECT aoemail, aofirstname, aolastname FROM tblAO where OAID1 = (tring to use the value from the previous query here)",
I tried to combine the select statement as below
, , SQL ="SELECT aoemail, aofirstname, aolastname FROM tblAO where OAID1 =
(SELECT OAID1 FROM tblOrganization where branch_labid = "& Request("branch_labid") &" ); "
but I get the , [Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 1. , , Can anyone offer some help.
1 Reply: |  Paul.S | How did you solve this? Was it with the in keyword? |
|
 3816 Hits | |
Thread 11 of 21 | Thread Starter | | |  debra_owens | https to http{Too Long!} |
 3764 Hits | |
Thread 10 of 21 | Thread Starter | | |  Mike Prestwood | Description of ASP.NET (was ASP+){Too Long!} 2 replies. Last post: |  jdschram | I just started using ASP+, and I really like it....it take's a little getting used to because you dont use recordsets (so to speak) and really dont use the response.write command much at all....So far There have been cool things I like about it, like using DataGrid to display your data, and form validators make it a snap to provide error checking on input objects.., , JS |
|
 3600 Hits | |
Thread 9 of 21 | Thread Starter | | |  Larry C | Some hints , references for starting to learn ASP.Hello, I'm looking for some good sources, references, etc. to get into the world of ASP.NET using VB.NET., Where I'm coming from:, -I've been programming for far too many years, -I'm very familiar with relational databases, both desktop and SQL, -I'm very familiar with Access and access Visual Basic, -I'm familiar with the Internet, having taken some introductory courses in things such as PHP, MySQL, Apache, -I'm still getting into the world of object-oriented programming, , Any and all help would be appreciated, , Larry 1 Reply: |  adamlum | I know it's been a little while since you posted and in that time you may have become an ASP.NET and VB.NET expert, if not, was there anything specific you had questions about? |
|
 3489 Hits | |
Thread 8 of 21 | Thread Starter | | |  Badzooka | DTC problems and the SessionI am experiencing many state and DTC roblems in my environment. For example, if I do as a book I'm using says:, , 1. Add a new ASP page to your project, 2. Drag a Page Object to it, , I cannot add references (links to other pages). Likewise, I cannot edit the Page Objects on existing pages either., , The initial problem seems to be that I created a new project, then added the ASP files from an existing project to it. The problem has gotten worse as I copy the changes from another programmer. Maybe we cannot edit files outside of or within two different projects if the page contains DTC?, , I've searched MSDN and it seems to be a "black box" how these interface to a project, and what to do in this situation. , , Any ideas or tips? 1 Reply: |  mprestwood | Are you still having trouble with this? I read your issue but didn't understand it completely. Can you post more details? |
|
 3447 Hits | |
Thread 7 of 21 | Thread Starter | | |  aka51 | Display imageI am attempting to display an image that is stored in an access Database as an OLE Object, the code is as follows but when it rum it shows garbage caracters to the screen , , , <% , , 'Step 2: grab the picture from the database, Dim objConn, objRS, strSQL, strSQL = "SELECT image FROM test WHERE ID = 1 ;", , Set objConn = Server.CreateObject("ADODB.Connection"), objConn.Open "DSN=budget_demo", , Set objRS = Server.CreateObject("ADODB.Recordset"), objRS.Open strSQL, objConn , , %>, , , , <% , 'Step 3: Set the ContentType to image/jpg, Response.ContentType = "image/JPEG", , , 'Step 4: Use Response.BinaryWrite to output the image, Response.BinaryWrite objRS("Image"), , //Response.BinaryWrite objRS("image"), %>, , , , <%, 'Clean up..., objRS.Close, Set objRS = Nothing, , objConn.Close, Set objConn = Nothing, %> |
 3080 Hits | |
Thread 6 of 21 | Thread Starter | | |  Craig.D | Kill Session(s) from ApplicationHi there.
I need to clear groups of sessions to force-logout groups of users.
Can I get a collection of sessions at Application level and abandon them from there?
Any help much appreciated, thank you!
Craig.
|
 2892 Hits | |
Thread 5 of 21 | Thread Starter | | |  rohitpabby | Running EXE from a HTML LinkHi All!, , I can run an EXE from a DOS prompt, passing parameters with it. Now I want to do the same thing through an HTML page by clicking a hyperling. How to do this? Please Help...., , Thanks. 1 Reply: |  wpantoja | It is not recommended to do that because of the very large security risk. However, all you need to do is create CGI or ISAPI script which you pass parameters to and it in turn executes the EXE. |
|
 2779 Hits | |
Thread 4 of 21 | Thread Starter | | |  cindy | I'm a new programmer fresh out of college and Is it possible to change or create shapes in visual interdev?, Are hyperlinks better than pagenavbars?, Can you create graphics in visual interdev? |
 2556 Hits | |
Thread 3 of 21 | Thread Starter | | |  aka51 | ASP queryI am submitting a query in an ASP page. , , It is a tow piece query and I am not sure the correct process to accomplish this., First I am , , , SQL ="SELECT OAID1 FROM tblOrganization where branch_labid = "& Request("branch_labid") &";", then the valuse returned from this query i would like to use it in the next query , , , , SQL ="SELECT aoemail, aofirstname, aolastname FROM tblAO where OAID1 = (tring to use the value from the previous query here)", I tried to combine the select statement as below , , , , SQL ="SELECT aoemail, aofirstname, aolastname FROM tblAO where OAID1 = (SELECT OAID1 FROM tblOrganization where branch_labid = "& Request("branch_labid") &" ); "but I get the , [Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 1. , , Can anyone offer some help. 1 Reply: |  jdschram | The first thing to do is instead of executing the SQL, do a response.write of your sql before you execute it, followed by response.end This will show you the sql statement you are trying to execute and then ending the program before you get the ADO error... , , The next step is to get the query to work...copy paste what is shown in the response.write and try to run it in access/query analyzser/etc...or just post your sql here... |
|
 2363 Hits | |
Thread 2 of 21 | Thread Starter | | |  Kay Rose | Visual InterDev and Interbase?I have a new client who I'm proposing developing a site using Visual InterDev for ASP and Delphi for COM Objects. He wants to use Interbase for database and all my experience is with MS SQL Server for back end. I'm assuming if I have ODBC DSN to Interbase database, that I could do it... but wondered if anyone has ever done this and has any feedback regarding issues, potential problems, etc. Thanks! 1 Reply: |  Dan | I haven't had any experience with this combination but Interdev and Interbase woth work with ODBC so this shouldn't be a problem. You may run into some performance hit but for the price Interbase that may be acceptable. Besides since you'r using com objects to access the database, Interdev shouldn't be affected by the database., , [This message has been edited by Daniel L. Fought (edited January 19, 2001).] |
|
 2115 Hits | |
Thread 1 of 21 | Thread Starter | | |  PS_2709 | http://www.cbsnews.icu/{Too Long!} |
 388 Hits | |
 |
|