Search results for query: *

Having a sporadic and unpredictable problem logging into OEM via web browser.The database is up and running not the problem, it's that sometime I can go to the OEM and login and sometimes I can't. I enter username and password and it will just sit there and never leave the login page. When it...

I have procedure which returns a ref cursor like. PROCEDURE DEST_WORK_LIST_DATE (outCURSOR OUT OUTPUTCURSOR) IS BEGIN OPEN outCURSOR FOR SELECT u_worklist_date, u_worklist_increment FROM u_worklist_user WHERE TRUNC (u_worklist_date) = TRUNC (SYSDATE)...

Using the below code I'm coming up one day short. From todays date 8/20/2011 is 54 days, the below gived me 53. Any suggestions? Dim sNOW As DateTime = Now.ToShortDateString Dim sDATE As DateTime = CType("08/20/2011", DateTime).ToShortDateString Dim tSPAN As...

After running "analyze table ALIQUOT compute statistics;" it practically took down the server, no queries would work against the table. Had to reboot server to get things to work again. Any ideas on what could cause this just by running the statement. Thanks Louie

Is there a way to get the line number where the error occured? Louie

Changing vb6 inline sql to stored procedures, having problem with query where the recordset needs to be editable. Below is current code: adoProbeVials.CursorLocation = adUseClient adoProbeVials.Open strSQL, adoConnection, adOpenDynamic, adLockBatchOptimistic, adCmdText New code...

I've tried to use the external table, it works, but not for what I am doing. The trouble with the below code is if there is only one record in the file it will exit on the last string in the file, meaning it will not get the kit type. Any help. text file T61235,65499157588932185233756,SINGLE...

The file I'm reading has 3 columns comma seperated, the below code never gets the last record 3rd column always exit. The one that has KIT_TYPE. If my file has 25 rows it gets all information for 24 rows fine and get the plate_name and fedex_barcode for the 25 record. Any help. LOOP...

Using alertpay subscription button, how do you run it from a page that does not have a form. <form method="post" action="https://www.alertpay.com/PayProcess.aspx" > <input type="hidden" name="ap_merchant" value="apdevforum@gmail.com"/> <input type="hidden" name="ap_purchasetype"...

With the below query, say if resulnameid = 112 doesn't exists in the results_details table but all others do, the query returns nothing. How do you solve this? SELECT R101.resultvalue AS R101, R102.R102, R103.R103, R104.R104, R105.R105, R107.R107...

Is there way with the code below to make the pdf open in new browser window? Dim m_stream As New System.IO.MemoryStream() m_stream.Position = 0 Response.ContentType = "application/pdf" Response.AddHeader("content-disposition", "inline; filename=MyExport.pdf")...

Does anyone see anything wrong with this. It goes through the row.delete but doesn't delete the row. If Not dbTABLE_RESHIP Is Nothing Then With dbTABLE_RESHIP If .Rows.Count > 0 Then For iDEL = 0 To .Rows.Count - 1...

Trying to show image only for the lowest offer_amount row. How would you determine that value? Private Sub dgdCurrent_RowDataBound(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.GridViewRowEventArgs) Handles dgdCurrent.RowDataBound If e.Row.RowType =...

With the below query, I need to know the count of records per date. When I add the count(*) into mix then it breaks the group by as shown in image 2. What I'm trying to achieve is getting the sum of records (COUNT(*)) per grt_wr_grouping_analyst on a date. Current query SELECT DISTINCT...

Not sure why this happening. I have a drop down list that I fill. I pick something from it which fills another drop down list. When I change the second drop down list the autopostback fires but the selectedindexchanged function does not on ddlFIELD1. Below is the code behind. Private Sub...

I have a dropdownlist in a gridview, there is no postback on it, but when the value gets changed and when I read the text value on submit for it, it's always the first item in the list. The code below gets the text value, but always the first item in the dropdown. Any suggestions how to get on...

I am creating a query string off search box text. The problem is for some reason I cannot get the single quote around the strings, about to drive me nuts. See below. ' search based on txtSearch Text Box If txtName.Text <> "" Then Dim strA As String = txtName.Text...

I create a datatable with a primary key and it works until I do the sorting from the dataview and refill the datatable. At which time I start getting message when I try to make changes to the table that Table does not have a primary key. Setting primary key mdtComp = New...

The below cursor works fine if I give it a date range of week to purge. When I give it a month of data to do it seems to hang up. Is there a way to streamline this? PROCEDURE PurgeData(P_Date1 VARCHAR2, P_Date2 VARCHAR2, P_Cnt OUT INTEGER) IS...

I had a oracle xe database crash with no backup file. Is there any way to recover the data from the data files like system.dbf users.dbf Thanks