Search results for query: *

Thank you George - I got it working - here is the end result: Try Dim path As String = ("\\testSv\c$\VRFiles\liveoutputTEMP.csv") Dim path2 As String = "liveoutput" + tDate + ".csv" If File.Exists(path) = True Then Using sr...

The csv file is being created from a piece of software we bought - this software will only write to the server it resides on and the file it creates sometimes has garbage in it. I have no control over the output so I was hoping to modify/verify the data before I write to SQL. Thanks for the...

sql 2005 not all who wander are lost....

I need to insert into a database from a csv file. I started by copying the csv file into a data table and that works like a charm - I can step through this and I see the data in the table: Using sr As System.IO.StreamReader = System.IO.File.OpenText("\\testSv\c$\VRFiles\liveoutputTEMP.csv")...

you my friend are the BOMB - thank you!!! not all who wander are lost....

I am not getting back the value after the ">>>" and I will need that as well - I posted my test below: Declare @AppointmentNote VarChar(8000) Declare @ApptNote1 VarChar(8000) Declare @ApptNote2 VarChar(8000) Set @AppointmentNote = 'CoPay required no gado <<<<recondo received>>> test' SET...

works like a charm - THANK YOU!!! not all who wander are lost....

I either add or update a field based on whether or not data exists in that field. Example: I am looking for the following "<<<Recondo Received 9/28/10>>>" in a text field The field may look like this: CoPay required <<<Recondo Received 9/28/10>>> no gado Using the following fails if the...

I did read your email - and I thank you! I came up with the following - I'm not returning anything yet but I think I am close ALTER proc [dbo].[psp_RecondoDate] @inDate nvarchar(100) AS DECLARE @outdate nvarchar(100) DECLARE @newInDate datetime SET @newindate =...

We use an HL7 engine to move messages from our RIS to both our internal and external partners - however - the engine cannot recognize that this is a date and add 2 days. My results for '20100730' came out as '20100732' and invalid dates fail to pass at our partner. I am closer to resolving this...

I am hoping someone can help me - I need to add 2 days to a date - the data comes in like '20100730'. Has anyone used dateadd in a stored procedure before? I have the following in a stored procedure: ------------------------------------------------- ALTER proc [dbo].[psp_RecondoDate]...

Thank you everyone - here is what I ended up with(after 16 hours of looking at it): in my HTML: <input type="hidden" id="Hidden1" name="Hidden1" runat="server"> my vb code: Protected Hidden1 As System.Web.UI.HtmlControls.HtmlInputHidden In my page load: Private Sub Page_Load If...

Hello Mark, Thanks for looking into this... I tried the code in the link - however - the update button is a template button on the datagrid and onClientClick is not an option fron the update on the grid. Is it possible to have a messagebox that can return a yes or no value from the...

I am a newbie... I have a datagrid in asp.net where our users record the number of steps they have walked since last week - this works great - however - I have been asked to add a confirm button that will basically say "Are you certain you want to post xxx steps today" after the user clicks...

Using the VB package and deployment wizard, I installed an application on a user's PC. When I am logged in as admin, the application runs with out problems. However, when the user logs in, they get the following message: Runtime Error '339' Component 'msflexgrd.ocx' or one of its dependencies...

...'Get all of the acks from the ack table. Dim rst As New ADODB.Recordset Dim sql As String Dim cntAcks As Integer sql = "select count (*) from Ack as [cntAcks]" rst.Open sql, con, adOpenDynamic, adLockOptimistic cntAcks = rst.RecordCount Set getAck = rst End Function...

Thanks for the quick response - Let me mention I am a newbie. I believe that I have followed your instructions correctly, but the error I get is: Line 3: Incorrect syntax near '.'. Line 3 is: as Transcripts.Recordid... I tried the following: SELECT DISTINCT oldack.trans_recordid...

I have two tables I need to join to populate an excel spreadsheet. The following statement works, but, now I need to modify to select only distinct oldack.trans_recordid. The oldack.date is the primary key. Here is my select statement: SELECT oldack.[Date], oldack.ack, oldack.visit_id...

Thank you. I do need to add to my inquiry. How do I create the second popup from the 1st popup when quitting out of the 1st popup?

In my application, closing a popup window causes other activity to take place in the background. Is it possible to display another popup for 10 seconds notifying the user to just sit tight while my others tasks are completing?