User Profile

Collapse

Profile Sidebar

Collapse
jayman9782
jayman9782
Last Activity: Apr 5 '08, 03:18 PM
Joined: Mar 6 '08
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • jayman9782
    replied to SQL Update with join
    in SQL Server
    I actually tried that as well...and ran a select query on the tables just to make sure the values were being picked up correctly. All seemed well. The frustration and time wasted got the better of me...I cheated by exporting the data to an access mdb, making the conversions and re-importing the data back into the sql server. This doesn't mean i wouldn't like to figure this out if you have any other suggestions. thanks.
    -Jay
    See more | Go to post

      Leave a comment:

    • jayman9782
      replied to SQL Update with join
      in SQL Server
      It does not create an error, rather it updates the [Dept Request] field to 0 where the inner join is true and <null> where the inner join is false. It should be updating this field to the value of [BY Request] from the joined table.
      See more | Go to post

        Leave a comment:

      • jayman9782
        replied to SQL Update with join
        in SQL Server
        Thanks for the quick response CK...but that was what I originally tried. It had the same results as the query i posted. any other suggestions?
        See more | Go to post

          Leave a comment:

        • jayman9782
          started a topic SQL Update with join
          in SQL Server

          SQL Update with join

          Someone please help. I'm running the following SQL query in sql server 2000...

          UPDATE S
          SET S.[Dept Request] = B.[BY Request]
          FROM [Budget Details - 2007] B LEFT OUTER JOIN
          [SCI Transaction Summary] S ON B.[Account Key] = S.Account
          WHERE (S.[Year] = 2007)

          All it does is zero out the field I'm trying to update. I'm almost positive the syntax...
          See more | Go to post
          • jayman9782
            started a topic Javascript if... else... producing same no matter what the value
            in Javascript

            Javascript if... else... producing same no matter what the value

            I'm working with ASP.NET 1.1 and I am attempting to compare the value of a textbox on the pages onunload event. The screen that is open is a pop-up screen that can be opened from links on two different pages. What i want to do is cause a post back to the form from which the pop-up screen originated.
            Here is my code:
            Code:
            <script language="javascript" type=text/javascript>
//If the window is closed
function
            ...
            See more | Go to post
            • jayman9782
              replied to New to php
              in PHP
              apache is running...the script hits the web service when executed/compiled with Nusphere. any other suggestions??.. . i'd rather not uninstall/unconfigure my mysql and php installations but if i can't figure this out i may give phpeasy a try. thanks for the help.
              See more | Go to post

                Leave a comment:

              • jayman9782
                replied to New to php
                in PHP
                good suggestion but that didn't seem to do the trick.? is there maybe a copilation path or something that i may be missing in the php ini file? the host is seeing the pages, it's just not compiling the php script?
                See more | Go to post

                  Leave a comment:

                • jayman9782
                  started a topic New to php
                  in PHP

                  New to php

                  Ok, this is probably going to sound pretty stupid...so please bear in mind that I'm completely new to php programming. Interested in the buzz about php I've recently downloaded the newest version 5.2.5 as well as MySQL server 5.0 and will be hosting web apps on Apache 2.2. I wrote a very simple program to get a feel for the syntax of php/MySQL programming...
                  [php]
                  Test.php - user-entered name and username

                  <html>...
                  See more | Go to post
                  Last edited by ronverdonk; Mar 9 '08, 11:48 PM. Reason: code within tags
                  • jayman9782
                    replied to SQL Server does not exist, Access denied
                    in .NET
                    As of right now the authentication mode in the web configuration within the application is set to Windows. I believe (please correct me if i'm wrong) when run on the webserver should be authenticating through it's IIS setup. I just noticed the anonymous access was checked and apparently this can not be the case with windows-level authentication in the app. When i uncheck it, it requires the user to enter their domain logon information (even when...
                    See more | Go to post

                      Leave a comment:

                    • jayman9782
                      started a topic SQL Server does not exist, Access denied
                      in .NET

                      SQL Server does not exist, Access denied

                      Hey all,
                      I'm having a common problem under different circumstances. A little background information: I am running an "in-house" ASP web application in .NET 1.1 with a back-end in SQL Server 2000. The application is on a separate server from the SQL server. About 99% of the time users are able to sucessfully log into the SQL server and the other 1% of the time they get this nasty message "SQL Server does not Exist or Access Denied"....
                      See more | Go to post
                      No activity results to display
                      Show More
                      Working...