Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. jcs1953

    New table permissions

    Changed connection string from (local) to .\sqlexpress. Changed IIS user to aspnet All is well.
  2. jcs1953

    New table permissions

    In testing my website I found that I needed to add a few tables to the database. The website was designed using ASP.Net 2. Internet and intranet access (IIS 6) worked fine before and works now except when I need to access the new tables. Then I get the "can't find or you dont have permissions"...
  3. jcs1953

    Page Load or IsPostBack?

    OK. It only worked once. I'm open to suggestions.
  4. jcs1953

    Page Load or IsPostBack?

    Got it figured out. I used this: Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load If Not Page.IsPostBack Then Session("PatientName") = " " Session("startdate") = " " End If End Sub
  5. jcs1953

    Page Load or IsPostBack?

    On my web page I have a textbox in which the doctor enters a patient ID. A dropdown list is populated with the avaliable test dates when he enters a patient id and hits the Enter key. There are several other buttons on the page that allow him to pull up different test panels based on the patient...
  6. jcs1953

    Insert same column value into a table

    Not really, except in my case it was the easiest way out I could think of. The table is small and will never have data added. I have two db, oracle and mssql. I have to combine the data from the two to display on a internal webpage. The oracle db table has the test name and the mssql table...
  7. jcs1953

    Insert same column value into a table

    I have a table in which I added a new column named test_name. I need to populate all rows in this new column with the same value (Sedrate). How can I do this? Thanks.
  8. jcs1953

    Using SQL Variables

    Wow! Complex answer to what I thought was a simple to answer question (although not so simple I could answer it). Here's my senerio. I have to pull data fro an Oracle Database (read only) and an sql database and combine the results. I used table.load() to combine the results into one table. The...
  9. jcs1953

    Using SQL Variables

    I'm having a real brain fart on this. I know how to use variables for column values in an sql statement in ASP.Net 2.0 but how do I word the function if the table name is the variable? Public Shared Function GetSQLTQResults(ByVal strtablename As String) As DataTable Dim strCon As...
  10. jcs1953

    Unique Dates and TRUNC

    Fiqured it out. I needed to change "ORDER BY REQ_PANELS.RUN_DATE" to "Order by 1
  11. jcs1953

    Unique Dates and TRUNC

    I have this query: SELECT ( REQ_PANELS.RUN_DATE) "Start_Date" FROM REQ_PANELS, REQUISITIONS, RESULTS, TESTS WHERE REQUISITIONS.ACC_ID = REQ_PANELS.ACC_ID AND REQ_PANELS.RP_ID = RESULTS.RP_ID AND RESULTS.TEST_ID = TESTS.TEST_ID AND (REQUISITIONS.PAT_ID = '10364.0') AND (REQ_PANELS.RUN_DATE IS...
  12. jcs1953

    Changing Default Printer

    Darn! Oh well. Thanks for the help.
  13. jcs1953

    Changing Default Printer

    Hi, I'm using this code to list the avaliable printers on the client side in a dropdownlist: For Each strPrinter As [String] In System.Drawing.Printing.PrinterSettings.InstalledPrinters SelectPrinter.Items.Add(strPrinter) Next strPrinter Dim PD As New PrintDocument...
  14. jcs1953

    HELP! Table Permissions.

    Got it figured out. Had to add aspnet user.
  15. jcs1953

    HELP! Table Permissions.

    I need some help quick. I have to present my website to the client this afternoon. IIS on 2000 Server on doc-server SQL Server 2005 Express on doc-server ASP.NET 2.0 Visual Web Developer 2005 Express on doc-server I added a table to an existing SQL database. All tables in the database need read...
  16. jcs1953

    Query on DataTable

    I have two queries , one from MSSQL and one from Oracle. The results are combined into one table using "mytable1.Load(dr2)". My question is can i run a query against mytable1? If I can't can I populate a table in my SQL database with the data in mytable1 and then run the query? How would I do...
  17. jcs1953

    Failed to enable constraints

    That's what it was ... the formats were different. Thanks
  18. jcs1953

    Alter Session

    I have a website in asp.net that uses queries to pull data from MSSQL and Oracle 10g and combine the data into one table. What I am having trouble with is date formats. The date format has to be the same for both the data retrieved from Oracle and MSSQL. MSSQL returns the date as mm/dd/yyyy...
  19. jcs1953

    Failed to enable constraints

    New Update. If I remove the date part in both queries then the tables combine. It's something to do with the dates. But what and how can I find out?
  20. jcs1953

    Failed to enable constraints

    The error occurs at "mytable1.Load(dr2)". The error is: System.Data.ConstraintException was unhandled by user code Message="Failed to enable constraints. One or more rows contain values violating non-null, unique, or foreign-key constraints." Source="System.Data" StackTrace: at...

Part and Inventory Search

Back
Top