Search results for query: *

I don't know if this is a VB question or Oracle, but the error I get is an ORA-00936 error, missing expression. This is the query I have: oracleTabwareBaseData = " SELECT DISTINCT WO_WORK_ORDER.WO_BASE, WO_WORK_ORDER.DESCRIPTION, WO_WORK_ORDER.PLANNER, WO_WORK_ORDER.REQUESTED_COMPLETION...

I am trying to update some form fields but each time I click the submit button it comes back with an error: Syntax error near keyword "where"... This is the code I have for the update statement: Sub Button_Update(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles...

I am trying to populate a drop-down based on a query, I have text boxes which I update using the DataFill method, so being the rookie I am, I thought I could do the same for drop downs, but not so... Const StrConnString As String = "server......=" Dim objConn As New...

For some reason when I format my message to HTML and then insert the <BR> command in the body of the email, it will not accept it; This is how I had set it up: objMail.BodyFormat = MailFormat.Html objMail.Body = "A Kaizen form has been submitted for your review please go to <a...

I am trying to send a hyperlink in an email generated by ASP.NET code, but it does not make the link active once it arrives in Email (Outlook 2003). Here's the code: Dim dt As DataTable Dim da As SqlClient.SqlDataAdapter dt = New DataTable("Supervisor") cmdSelect.Connection = objConn da = New...

Is there a way to call another batch file using a batch file in Windows? For some reason when I run the command in the command window (not using the batch file) it works, but as soon as I put the same command in the batch file, it fails?? This is what I am trying to batch: D: CD pi\adm...

For some reason this expression I have in my query calculates the wrong values for every other row? The calculation I have is as follows: Cycle Count: ([Std Pk Qty])*([Qty])/([CAV]) So for example: Row1: Std Pk Qty = 1 Qty = 1080 Cav = 4 hence, Cycle Count = 270 On Row 2 however, I have...

This is a complete rookie question as I never code in VB, well not much anyway. I have a table with a few columns, and when I query the table, I get about 4 rows of data, one of the columns I have Sum(col1+col2) As Cycles. Now the record "Cycles" I want to loop through each one and add the...

I have this script which I found online in a help forum and it works very nice, except now I want to try to learn more about formatting it so I can set page margins, etc. This is the script: <script language="javascript"> function CallPrint(divPrint) { var prtContent =...

This may be a very dumb question as I am surely overseeing something simple. I am trying to run a Javascript when someone pushes a button on my webform (asp.net), but it comes back with an error when the page loads, button is not even yet pushed. This is the code: <script language=javascript>...

I keep getting this error: Error: -2147217900 Error Description: [Microsoft][ODBC Microsoft Access Driver] The SELECT statement includes a reserved word or an argument name that is misspelled or missing, or the punctuation is incorrect. When I run this select statement in my VB code, I look...

I am trying to combine 2 queries in to one report and when I use the Wizard, I can pull the info from the first query, but as soon as I hit the 2nd query, it shows me no fields even though there are fields in the 2nd qry. I am wondering if the problem is that the 1st qry is a Crosstab qry? I...

I am trying to set up a table/form where a user enters some parts data, one of which is # of bad pieces, and then they have a category of "bad" that is tied to the # of bad pieces entered, but I also wanted to see if I could set up multiples instances of # bad pieces and category so that if User...

This is what I want to do, update a datagrid where a user enters some data, and this is the update part: Sub Update_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Update.Click Dim dgi As DataGridItem For Each dgi in DataGrid1.Items 'Read in the...

I keep getting this error message: The OleDbParameterCollection only accepts non-null OleDbParameter type objects, not String objects And I have been searching online but cannot find anything relevant to explain what I am missing... This is the code: Sub DataGrid1_Update(ByVal sender As...

I am trying to read through a number of rows/columns and extract the data in to text fields on a ASP.Net page; This is what I have for the code going through each row, but I am stuck on the procedure to extract the data in to my text fields For Each Row In myDataSet.Tables("[All PLants...

I have a bit of a dilemma, I have a datagrid with 3 columns that are pre-existing with the data each time it is displayed, then I have about 8 columns I need to edit/update the data fields; depending on the selection this can be anywhere from 4 rows of data up to 15 rows. Is there a way to...

I keep seeing this error from this code, the query does work in the database and it does display data, but when I run this in ASP.net, I get the error... Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load Dim connectString As String =...

I have done this before when each field was a unique field from a database, but this time I have 3 columns, all named the same, but several rows of data, and I need to fill each field in my .NET page from the database, but I am not sure how to continue... This is the code I have so far: Dim...

I keep seeing this error when I run this query and I know the error points to this part of the query: AND TO_DATE(EQ_EVENTS.EVENT_END_DATE, 'MM/DD/YYYY') = TO_DATE(SYSDATE-24 , 'MM/DD/YYYY') This is the complete error: ORA-01858: a non-numeric character was found where a numeric was expected...