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
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
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
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
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
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
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
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
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
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
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
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
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
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
View Answer | April 20, 2009 12:00 PM
ASP, ASP.NET, Session, Web application security, Web development
View Answer | April 20, 2009 11:53 AM
ASP, Java, onChange Event, PHP, SelectedIndex, VBScript
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
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
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