adding pictures in visual basic
Just some questions first. What version of Visual Basic are you using ? Do you want to know how to show the pictures in your application, or how to store and retrive them to/from the database ? If the latter, what database are you using ?

View Answer   |  April 22, 2009  5:53 PM
Visual Basic

onBlur event not calling javascript function
you are right, I needed to drop the date out of (this.date.value) got it working. thanks for your help Have you tried onblur=”isValidDate(this.value)”> Earl http://www.duckin4printing.com/

View Answer   |  April 22, 2009  4:02 PM
JavaScript, JavaScript Validation, onBlur

If Statement isn’t evaluating out correctly
Guys, I figured it out… the conditions weren’t being defined well enough for the ‘between’ values. Here are the changes I made to the If…Then… Else statements: If dOrderTotal >= 500 Then dDiscountPct = 0.2 ElseIf dOrderTotal >= 250 And dOrderTotal < 500 Then dDiscountPct = 0.15 ElseIf dOrderTotal >= 100 And dOrderTotal < 250 [...]

View Answer   |  April 22, 2009  1:20 PM
IF statement, VB.NET, VB.NET 2005, VB.NET 2005 Express Edition, VB.NET Express Edition

Multiple Tables to Bulk Import .sql script
I have been using the Lite version of Navicat Oracle for a couple of weeks now which compared it to Oracle’s SQL Developer and also Oracle Maestro. I have found Navicat to open quicker (especially compared to SQL Developer… java runs soooo slow!). I also find the interface/gui to be less cluttered and easier to [...]

View Answer   |  April 22, 2009  4:03 AM
Oracle, Oracle import/export, Oracle Table Export, SQL, Sql Script, TOAD

Visual basic beginner
b=a+2

View Answer   |  April 22, 2009  2:29 AM
Code example, Visual Basic

How to configure IIS for Web server with static IP
Firstly you have to have a static IP in your server. Then under IIS, Web Sites, right-click on the website that you want to configure. On Web Site tab you configure the IP address in Web Site Identification under “Description” That’s work for an internal network, for internet you’ll have to host this page usin [...]

View Answer   |  April 21, 2009  6:12 PM
IIS, IIS configuration, Static IP, Static IP address, Static IP Configuration, Web servers, Windows

Server environment for .NET applications
Windows IIS Server environment. It is the only server environment that can support .NET

View Answer   |  April 21, 2009  8:52 AM
.NET, .NET applications, Servers

How to restore the website from Production in a Virtual directory (copying all files) on PreProduction
Create the IIS website on the PreProduction server. Then copy all files over. Make sure the IIS security settings match and the asp version too.

View Answer   |  April 21, 2009  8:27 AM
Development Servers, IIS, IIS Virtual Directories, Production Servers, Web development

Recordset clobbers asp page
Your SQL connection code may not be right, also put some values in the undefined table fields.

View Answer   |  April 21, 2009  7:21 AM
ASP, Dreamweaver CS4, Recordset, SQL connection, VBScript

Presentation for Apache
I guess you refer to Apache webserver, if so please read the <a href=”http://httpd.apache.org/ABOUT_APACHE.html”>About page</a>, or the <a href=”http://en.wikipedia.org/wiki/Apache_HTTP_Server”>Apache HTTP Server page at Wikipedia</a>.

View Answer   |  April 20, 2009  5:51 PM
Apache

SQLRPG MaTERIAL
Try this link for programming reference, http://publib.boulder.ibm.com/infocenter/systems/scope/i5os/topic/rzajp/rzajp.pdf

View Answer   |  April 20, 2009  5:19 PM
SQL, SQLRPG

Multiple Join Update
This is an example of the syntax using Oracle: UPDATE ( SELECT a.field_y old, b.field_y new FROM table_a a INNER JOIN table_b b ON a.field_x = b.field_x) ) SET old = new WHERE <conditions>; Please modify it as needed. There are some restrictions, because you are really updating a view.

View Answer   |  April 20, 2009  5:13 PM
JOIN statement, SQL, SQL queries, UPDATE statement

Access 2007 table versus forms
Yes – that would delete the records from the original table I believe that you can create a query excluding the rows you don’t want to see and build the form over the view. Phil

View Answer   |  April 20, 2009  4:12 PM
Access 2007, Access forms, Access Tables, Microsoft Access

Unique ID for existing table
This could be different depending on the database, which you didn’t specify. If you already have data in the table, you will probably need to create a stored procedure to generate the sequential number for the existing records, and then set a trigger up to auto-generate the number when new records are inserted.

View Answer   |  April 20, 2009  4:09 PM
Auto increment, Database design, Database programming, SQL

Loading an XML file’s dataset into an existing SQL Server 2005 table
Hi you might consider using <a href=”http://msdn.microsoft.com/en-us/library/aa225754(SQL.80).aspx”>XMLBulkload</a> . I successfully used it in the past and it’s a really nice tool.

View Answer   |  April 20, 2009  3:40 PM
SQL Server 2005, SQL Server Dataset, SQL Server tables, XML

For Proper Log out in ASP web application.
When you click logout there will need to be an “extra page” so the sequence would be something like this. Logged in page click logout (submit to intermediate page) Intermediate page do your session.abandon set expires & cache to -1 & put in JS <script language=”javascript”> window.location=”finalpage.asp” window.history.forward(20); </script> response.redirect finalpage.asp final page finalpage.asp (landing [...]

View Answer   |  April 20, 2009  12:00 PM
ASP, ASP.NET, Session, Web application security, Web development

Passing selectedIndex value from ASP page to VBScript
You cannot pass JavaScript (Client Side Technology) dynamically to ASP (Server Side Technology). You can use JS to set values then collect those values when the form is submitted to the server. Earl http://www.duckin4printing.com/

View Answer   |  April 20, 2009  11:53 AM
ASP, Java, onChange Event, PHP, SelectedIndex, VBScript

Javascript clashing – Custom Scrollbar for Div not working with Hide Show Div Script
When you change the page color why not put the new color in a cookie using JS. Then when you go to the new page you check to see what the page color is in the cookie. Earl http://www.duckin4printing.com/

View Answer   |  April 20, 2009  11:45 AM
Div, hide div, Java, JavaScript, Javascript error, script, scroll

creating reports with forms/subforms
This looks like you have control element with data (emp.id) which absent from query underlying report. To print on separate page the data for each Employee ID number, add group by this column and set a page break at the beginning of this group.

View Answer   |  April 19, 2009  8:32 AM
Access 2000, Access forms, Microsoft Access, Microsoft Access forms, Microsoft Access subforms

Does something similar to Oracle’s optimizer hints exist in SQL Server ?
Yes to some extent. You can use locking hints to change the way that SQL Server locks the tables. You can use execution plan hints to change the way that SQL Accesses the table by forcing it to use a specific index. If you want to you can statically set an execution plan into the [...]

View Answer   |  April 19, 2009  8:06 AM
Microsoft SQL Server, Optimizer, Oracle, SQL, SQL Server, SQL tuning