Constraints (MySql,tables,null,PK,FK etc)
I would take Carlosdl advise and read up. Here is how I would do this: CREATE TABLE department( departmentId INT NOT NULL PRIMARY KEY AUTO_INCREMENT, departmentNumber VARCHAR(16), departmentName VARCHAR(64) NOT NULL, isEnabled TINYINT NOT NULL ); CREATE TABLE course( courseId INT NOT NULL PRIMARY KEY AUTO_INCREMENT, departmentId INT NOT NULL, courseNumber VARCHAR(16), courseName VARCHAR(64) NOT [...]
View Answer
| January 23, 2010 6:42 PM
constraints, foreign key, MySQL, NOT NULL, NULL, primary key, tables
I would take Carlosdl advise and read up. Here is how I would do this: CREATE TABLE department( departmentId INT NOT NULL PRIMARY KEY AUTO_INCREMENT, departmentNumber VARCHAR(16), departmentName VARCHAR(64) NOT NULL, isEnabled TINYINT NOT NULL ); CREATE TABLE course( courseId INT NOT NULL PRIMARY KEY AUTO_INCREMENT, departmentId INT NOT NULL, courseNumber VARCHAR(16), courseName VARCHAR(64) NOT [...]
View Answer
| January 23, 2010 6:42 PM
constraints, foreign key, MySQL, NOT NULL, NULL, primary key, tables
A framework compatible with oracle 10g
<a href=”http://www.microsoft.com/downloads/details.aspx?FamilyID=4F55D429-17DC-45EA-BFB3-076D1C052524&displaylang=en”>This</a> is the MS provider that I use. You will need to have the appropriate Oracle client installed. http://msdn.microsoft.com/en-us/library/ms973871.aspx
View Answer
| January 23, 2010 1:57 PM
.NET, Framework 3.5, Oracle 10g
<a href=”http://www.microsoft.com/downloads/details.aspx?FamilyID=4F55D429-17DC-45EA-BFB3-076D1C052524&displaylang=en”>This</a> is the MS provider that I use. You will need to have the appropriate Oracle client installed. http://msdn.microsoft.com/en-us/library/ms973871.aspx
View Answer
| January 23, 2010 1:57 PM
.NET, Framework 3.5, Oracle 10g
Email Notification
Here is the function I wrote and use in my code. You will need to Import System.Net and System.Net.Mail at the top of the page you put it in. Below the code is the link to the reference pages for these two classes. <pre> Private Function SendMail(Server As String, User As String, Password As String, [...]
View Answer
| January 23, 2010 3:02 AM
SQL Server database, VB.NET
Here is the function I wrote and use in my code. You will need to Import System.Net and System.Net.Mail at the top of the page you put it in. Below the code is the link to the reference pages for these two classes. <pre> Private Function SendMail(Server As String, User As String, Password As String, [...]
View Answer
| January 23, 2010 3:02 AM
SQL Server database, VB.NET
Most efficient cron command to call a php script?
wget -q -t 1 -O /path_to_dir/file_name URL >> /dev/null 2>&1 Should do the trick. The only output generated by this should only be the file you asked it to make. With the exception of errors. If your command generated an error, the errors will go to the log file.
View Answer
| January 22, 2010 7:53 PM
cron jobs, PHP Coding, PHP scripts
wget -q -t 1 -O /path_to_dir/file_name URL >> /dev/null 2>&1 Should do the trick. The only output generated by this should only be the file you asked it to make. With the exception of errors. If your command generated an error, the errors will go to the log file.
View Answer
| January 22, 2010 7:53 PM
cron jobs, PHP Coding, PHP scripts
Vbscript converting numeric month to specified letter
You need to use the chr function: sYesterday = 1000000 * Day(dYesterday) + 10000 * Chr(64 + Month(dYesterday)) + Year(dYesterday) Chr(64 + 1) will give you A Chr(64 + 2) will give you B Chr converts an integer in the range of the ASCII characters and turns in into the approporate ascii character. 65 is [...]
View Answer
| January 22, 2010 5:12 PM
VBScript, VBScript Debugging
You need to use the chr function: sYesterday = 1000000 * Day(dYesterday) + 10000 * Chr(64 + Month(dYesterday)) + Year(dYesterday) Chr(64 + 1) will give you A Chr(64 + 2) will give you B Chr converts an integer in the range of the ASCII characters and turns in into the approporate ascii character. 65 is [...]
View Answer
| January 22, 2010 5:12 PM
VBScript, VBScript Debugging
OnClick Event of Radio Button DOES NOT WORK in either Firefox or IE
You need to dynamically add asp.net controls to the form and then tie events to them. See <a href=”http://www.dreamincode.net/forums/showtopic39831.htm”>this</a> post.
View Answer
| January 22, 2010 6:10 AM
ASP.NET, ASP.NET 2008, VB, Visual Basic
You need to dynamically add asp.net controls to the form and then tie events to them. See <a href=”http://www.dreamincode.net/forums/showtopic39831.htm”>this</a> post.
View Answer
| January 22, 2010 6:10 AM
ASP.NET, ASP.NET 2008, VB, Visual Basic
how to handle single value and multiple values columns at the time of display in C#
To get customer info with a count of how many items they ordered: SELECT t1.customerName, t1.address, t1.phone, SUM(t2.qty) FROM t1 INNER JOIN t2 ON t1.customer = t2.customer GROUP BY t1.customerName, t1.address, t1.phone I’m assuming that t1 and t2 have some customer number in common. If you want all the customer info and all of the [...]
View Answer
| January 22, 2010 5:54 AM
.NET, C#, Crystal Reports
To get customer info with a count of how many items they ordered: SELECT t1.customerName, t1.address, t1.phone, SUM(t2.qty) FROM t1 INNER JOIN t2 ON t1.customer = t2.customer GROUP BY t1.customerName, t1.address, t1.phone I’m assuming that t1 and t2 have some customer number in common. If you want all the customer info and all of the [...]
View Answer
| January 22, 2010 5:54 AM
.NET, C#, Crystal Reports
How to fetch data from notepad in VB6.0 like a backend database
Either put this in a a open buttons click event or do it when the form loads: Open “C:path_to_your_filefile_name.txt” For Input as #1 pub this in your next buttons event: Dim temp as String Dim data() As String Do While Eof(1) = 0 line input #1,temp data = Split(line, “,”) TextBox1.Text = data[0] TextBox2.Text = [...]
View Answer
| January 22, 2010 5:31 AM
Notepad, VB 6.0, Visual Basic
Either put this in a a open buttons click event or do it when the form loads: Open “C:path_to_your_filefile_name.txt” For Input as #1 pub this in your next buttons event: Dim temp as String Dim data() As String Do While Eof(1) = 0 line input #1,temp data = Split(line, “,”) TextBox1.Text = data[0] TextBox2.Text = [...]
View Answer
| January 22, 2010 5:31 AM
Notepad, VB 6.0, Visual Basic
How do I import GPOs from an old domain into a new domain with VBScript?
Instead of programing a VBscript, it might be easier to <a href=”http://technet.microsoft.com/en-us/library/cc779123(WS.10).aspx”>import the GPOs using the GPMC</a>.
View Answer
| January 22, 2010 12:02 AM
GPOs, Group Policy Objects, VBScript
Instead of programing a VBscript, it might be easier to <a href=”http://technet.microsoft.com/en-us/library/cc779123(WS.10).aspx”>import the GPOs using the GPMC</a>.
View Answer
| January 22, 2010 12:02 AM
GPOs, Group Policy Objects, VBScript
export VB6 report in pdf format.
Your going to have to use a third party DLL. I would reccomend avoiding this all togetehr and instead installing something like: <a href=”http://sourceforge.net/projects/pdfcreator/”>PDFCreator</a> on the users computer so they can print the crystal report to pdf.
View Answer
| January 21, 2010 8:59 PM
Access Database, Crystal Reports, Microsoft Access, VB6, Visual Basic
Your going to have to use a third party DLL. I would reccomend avoiding this all togetehr and instead installing something like: <a href=”http://sourceforge.net/projects/pdfcreator/”>PDFCreator</a> on the users computer so they can print the crystal report to pdf.
View Answer
| January 21, 2010 8:59 PM
Access Database, Crystal Reports, Microsoft Access, VB6, Visual Basic
How to connect asp.net with sql 2005
Imports System.Data.SqlClient Sub SaveData(Name As String, Surname As String, Email As String, Comments As String) Dim cn As SqlConnection Dim cmd As SqlCommand Dim intResult As Integer cn = new SqlConnection(“Data Source=myServerAddress;Initial Catalog=myDataBase;User Id=myUsername;Password=myPassword;”) cmd = new SqlCommand(“”, cn) cmd.CommandText = “INSERT INTO table_name(name, surname, email, comments) VALUES(‘” & Name & “‘, ‘” & Surname [...]
View Answer
| January 21, 2010 8:53 PM
ASP.NET Web applications, SQL Server 2005 connectivity
Imports System.Data.SqlClient Sub SaveData(Name As String, Surname As String, Email As String, Comments As String) Dim cn As SqlConnection Dim cmd As SqlCommand Dim intResult As Integer cn = new SqlConnection(“Data Source=myServerAddress;Initial Catalog=myDataBase;User Id=myUsername;Password=myPassword;”) cmd = new SqlCommand(“”, cn) cmd.CommandText = “INSERT INTO table_name(name, surname, email, comments) VALUES(‘” & Name & “‘, ‘” & Surname [...]
View Answer
| January 21, 2010 8:53 PM
ASP.NET Web applications, SQL Server 2005 connectivity
How to use substring to separate words
Dim names() As String name = TextBox1.Text.Split(” “) If name.Length = 2 Then Label1.Text = name(0) Label2.Text = name(1) Else MessageBox.Show(“Please enter a first and last name.”); End If
View Answer
| January 21, 2010 8:40 PM
Visual Basic
Dim names() As String name = TextBox1.Text.Split(” “) If name.Length = 2 Then Label1.Text = name(0) Label2.Text = name(1) Else MessageBox.Show(“Please enter a first and last name.”); End If
View Answer
| January 21, 2010 8:40 PM
Visual Basic
About VB6.0 screen objects
This article has a summary of it with a few examples. http://www.qualitycodes.com/tutorial.php?articleid=9&pageid=59 VB6 stuff is disappearing rapidly of the net. I would recommend you get a reference book for it from your favorite book seller.
View Answer
| January 21, 2010 8:30 PM
VB 6, VB 6.0, Visual Basic, Visual Basic 6
This article has a summary of it with a few examples. http://www.qualitycodes.com/tutorial.php?articleid=9&pageid=59 VB6 stuff is disappearing rapidly of the net. I would recommend you get a reference book for it from your favorite book seller.
View Answer
| January 21, 2010 8:30 PM
VB 6, VB 6.0, Visual Basic, Visual Basic 6
how to open crystal report in new window
Here is how I would accomplish this. When the button is clicked to view the report, do this: Response.Write(“<script type=’text/javascript’>window.open(‘../ViewReport.aspx?parameter=” & strValue & “‘, ‘_blank’, ‘width=800,height=600′);</script>”) Now build ViewReport.aspx with the CR Viewer on it. In the page load event, read the parameters out of Request.QueryString feed them to the report. Now when the click [...]
View Answer
| January 21, 2010 8:15 PM
ASP.NET 2.0, C#, Crystal Reports, Crystal Reports XI
Here is how I would accomplish this. When the button is clicked to view the report, do this: Response.Write(“<script type=’text/javascript’>window.open(‘../ViewReport.aspx?parameter=” & strValue & “‘, ‘_blank’, ‘width=800,height=600′);</script>”) Now build ViewReport.aspx with the CR Viewer on it. In the page load event, read the parameters out of Request.QueryString feed them to the report. Now when the click [...]
View Answer
| January 21, 2010 8:15 PM
ASP.NET 2.0, C#, Crystal Reports, Crystal Reports XI
date count down in VB 6
The instructions in this article will assist you in getting a timer set up: <a href=”http://www.vb6.us/tutorials/understanding-timer-control-vb6″> You will want to add these lines to the tmrTest_Timer sub: If Date() = DateValue(’01/01/2010′) & Time() >= TimeValue(’01:00 PM’) Then tmrTest.Enabled = False MsgBox(“Due date reached.”); End If
View Answer
| January 21, 2010 7:59 PM
VB 6, Visual Basic, Visual Basic 6
The instructions in this article will assist you in getting a timer set up: <a href=”http://www.vb6.us/tutorials/understanding-timer-control-vb6″> You will want to add these lines to the tmrTest_Timer sub: If Date() = DateValue(’01/01/2010′) & Time() >= TimeValue(’01:00 PM’) Then tmrTest.Enabled = False MsgBox(“Due date reached.”); End If
View Answer
| January 21, 2010 7:59 PM
VB 6, Visual Basic, Visual Basic 6
PDF COMPLETE: CROP, COPY, PASTE ONTO A POWER POINT
Look’s like they may have disabled this feature in newer versions of Acrobat Reader. Here is another way to do it. <ol> <li>Zoom the PDF until the image you want is the size you want it.</li><li>Hold down the ALT key on your keyboard.</li><li>Press the Print Screen key on your keyboard (usually above the insert home [...]
View Answer
| January 21, 2010 7:33 PM
Adobe Acrobat, PDF, PDF Complete
Look’s like they may have disabled this feature in newer versions of Acrobat Reader. Here is another way to do it. <ol> <li>Zoom the PDF until the image you want is the size you want it.</li><li>Hold down the ALT key on your keyboard.</li><li>Press the Print Screen key on your keyboard (usually above the insert home [...]
View Answer
| January 21, 2010 7:33 PM
Adobe Acrobat, PDF, PDF Complete
How do I place duplicate directly below the copied record?
A form is just a method of displaying the records, so it doesn’t go about ordering them in any way, unless you specify a sort order in your query. If the records have an id of some description that you can use to group them, then use that as the order by clause, and then [...]
View Answer
| January 21, 2010 2:14 PM
Microsoft Access, Microsoft Access forms
A form is just a method of displaying the records, so it doesn’t go about ordering them in any way, unless you specify a sort order in your query. If the records have an id of some description that you can use to group them, then use that as the order by clause, and then [...]
View Answer
| January 21, 2010 2:14 PM
Microsoft Access, Microsoft Access forms
Port Parameter on FTP command
It connected with the alternate port when I tried it. My system is at V5R3. PGM FTP RMTSYS(SYSTEM2) PORT(10343) ENDPGM ==================================================== Since we can’t see the CL program you run nor the joblog nor are we told any attributes of the job that runs the CL, there’s not much chance we can figure it out. [...]
View Answer
| January 21, 2010 8:50 AM
Application development, CLP
It connected with the alternate port when I tried it. My system is at V5R3. PGM FTP RMTSYS(SYSTEM2) PORT(10343) ENDPGM ==================================================== Since we can’t see the CL program you run nor the joblog nor are we told any attributes of the job that runs the CL, there’s not much chance we can figure it out. [...]
View Answer
| January 21, 2010 8:50 AM
Application development, CLP
SQL transcation log file
You’ll want to look at Lumigent’s Log Explorer and Quest Software’s LiteSpeed for SQL Server. These are pretty much the only two products which allow you to read the SQL Transaction log.
View Answer
| January 20, 2010 8:45 PM
Log files, SQL
You’ll want to look at Lumigent’s Log Explorer and Quest Software’s LiteSpeed for SQL Server. These are pretty much the only two products which allow you to read the SQL Transaction log.
View Answer
| January 20, 2010 8:45 PM
Log files, SQL
Simply, How do I populate Fields from a SQL Statement in Oracle Apex?
UPDATE: I’ve tried using HTMLdb_get, now, with errors, of course…still no success in such a stupid task. I’ve used Ingres and Access and was able to get results in minutes. Oracle Apex is capable of producing what it wants as far as forms go, but, as far as I can tell, it is more trouble [...]
View Answer
| January 20, 2010 6:15 PM
Oracle Apex, PL/SQL, SQL, SQL statements
UPDATE: I’ve tried using HTMLdb_get, now, with errors, of course…still no success in such a stupid task. I’ve used Ingres and Access and was able to get results in minutes. Oracle Apex is capable of producing what it wants as far as forms go, but, as far as I can tell, it is more trouble [...]
View Answer
| January 20, 2010 6:15 PM
Oracle Apex, PL/SQL, SQL, SQL statements
