65 Discussion / Question Topics
Remove Filter  | Hi All, I have a simple form that I want to send me an email when the button is clicked. I have two questions, 1. How can I make the fields Name and Email mandatory? 2. It does not send an email to me when used with my smartphone, which … |
| | Hi All, I'm looking for some advice. After having to take about two years off from university due to suffering from viral meningitis, I have finally gone back and finished my undergraduate degree in Information Systems, which is a stream from the applied computer sciences. I am very excited to …  |
| | Hi All, This is a rant as well as a discussion. First, some background: On this forum and another forum I frequent I have been seeing a lot of the "Please help, I cannot figure out my assignment" type of questions. Just today in the Software Development forum someone is …  |
| | Hi All, I have recently viewed something that I have never seen before with regards to a computer. I saw a window close and open really fast, at least 10 times upon startup. It looked like the cmd.exe window but I only saw a video of it happening and it … |
| | Hi All, I'm working on a script which has a primary function to look for jpg files. I can get it to work if the folder path is just my desktop but if I try the start of the path to be C:\ it errors out. Right now the error … |
| | Hi All, I have two issues that I cannot seem to resolve using Google. 1. My windows account, the only one I have, is the Admin account. However, I cannot save files on my desktop and get prompted that only the admin can save there and that I should contact … |
| | Hi All, I have a Dell PC for which I am attempting to install Windows 7 onto a new HDD I bought. However, I am having issues with not being able to Boot the disk that has the Windows 7 iso. What I've done: 1. Seated the new HDD 2. … |
| | Hi All, I'm wondering if anyone from here, a good trusted source of information, has heard of Heartbleed? > Two days ago a serious vulnerability (that’s been named “Heartbleed”) in the popular cryptographic software OpenSSL was made public. This weakness could potentially be exploited to steal information, such as login …  |
| | On my Facebooks there are a lot of posts from people that are really worried about WW3 popping off because of the Russian takeover of Ukraine. I've read some interesting articles from different countries that denounce Russia's actions and there's talk of economic sanctions from the US and other countries …  |
| | What does it mean to be "Featured" and a "Colleague" here at Daniweb? How does one aspire to claiming such tag-titles? |
| | Not sure if this is the right spot for this question but I'm here! I'm trying to make a vb script that opens large text files, one at time, searches each line for Null values (there can be many) and then replaces them with a space. My coworker put the … |
| | Hi all, I'm going nuts with my laptop. I installed gparted, backed up my fil, and then let gparted do its thing. I then went to reinstall Ubuntu with a disc but I keep getting the following messages: "xhecking media [fail]. No boot device found. Press any key to continue". … |
| | Hi All, I've been helping a friend with a site that he's been designing with godaddy.com. It's pretty cool and easy to do with their templates and all but their like buttons are troublesome and I was hoping to get some knowledge about this from here. Lets say there are … |
| | Hi All, I've had Ubuntu for a couple of months now and I'm having problems with the boot drive/partition. I have a total of 500 GB to work with but for some reason that I didn't notice Ubuntu installed using only a (very) small portion of my 500 GB and … |
| | Hi All, THis is just a basic question about Wine. How many use it on Linux and how many are happy with it? I've seen mixed reviews about Wine on the internets so I thought I would ask the only tech community that matters. I just installed it because I … |
| | Hi All, I'm attempting to install Jre7 on my newly installed Ubunto OS. I've been looking [here](http://askubuntu.com/questions/56104/how-can-i-install-sun-oracles-proprietary-java-6-7-jre-or-jdk) and it is telling me to move the unzipped folder to /usr/lib but where is that? In the Terminal I tried finding it by changing directories but to no avail and I'm getting …  |
| | Hi all, I'm trying to get Ubuntu to work but at boot up I get issues. I took a picture and I don't know how to procede. |
| | Trying to upload a picture. Ack, the picture size is too big, even zipped.  |
| | Hi All, I'm trying to loop through and open PDFs in a folder using Java. I have the following code: import java.awt.Desktop; import java.io.File; import java.io.IOException; public class OpenPDFs { public static void main(String[] args) throws IOException { // TODO code application logic here String fp; fp ="S:\\Economic Forecasts\\Fcst13\\SourceForecasts\\"; File … |
| | Hi All, I am creating a simple query with a not so simple twist, at least it's not simple to me. First, the query: select distinct b.Bank_Mnemonic as [Bank],bd.Demo_Name as [Demography],ei.BEFI_Description[Economic Indicator],bsd.BSD_Year as [Year],bsd.BSD_Data_Value as [Value] from dbo.tblBank_Source_Data as bsd inner join dbo.tblBankDemographics as bd on bsd.Demo_ID=bd.Demo_ID inner join dbo.tblBanks … |
| | Hi All, I have an SSIS question regarding looping through CSV files with the Foreach Loop Container. What I have: 1. A string variable named fName - Global 2. A Foreach Loop Container 2.1 User::fName mapped to the loop container with an index of 0 3. A Data Flow Task … |
| | Hi All, Hopefully I don't get too scolded here for this question but I can't commit my mind to answer this as I have been ill and am still not fully recovered. In saying that, I have the following set of tables (see pic) and I need to fill in … |
| | I just wanted to share my thoughts regarding PDFs and how bad they are to work with. I have 8 bank sources that provide my department with quarterly forecast data and their outputs are always in PDF format. I know PDFs are a convenient way to output data and are …  |
| | Hi All, This is something I should know but for whatever reason today it is eluding my mind. I'm trying to query our database to provide me with data between March 2012 and March 2013. Initially, I had the following line: where a.IPI_Ref_Date between '2012' and GETDATE() and the output … |
| | I just wanted to test starting a thread to see the popup prompt. Please delete if you like (mods or admin). |
| | Hi All, With SSIS, upon load, I am receiving the following error: > Error 1 Error loading DownloadCSVPackage.dtsx: The connection "" is not found. This error is thrown by Connections collection when the specific connection element is not found. C:\Projects\EconAnalysisStatsCan\EconAnalysisStatsCan\DownloadCSVPackage.dtsx 1 1 I have gone through all of my connections … |
| | Hi All, I met with some people from a private firm that has been hired to automate some data flows from PDF files to Excel and then to SharePoint. I wrote some VBA code for them to brute-force-test and they were impressed with what I had accomplished. The one fellow, … |
| | Hi All, Since most of you are professionals and I'm trying to be a professional at work I thought I would pop this question at you. Have you ever had one of those days where your coding stinks, errors are difficult to find, and no matter how you proceed with … |
| | Hi All, I'm curious as to why there is no MS Office help forum here? This site is so diverse but yet it doesn't noticably deal with Office products like Excel. I know there are a lot of forums out there which offer Excel and other Office help but it … |
| | Hi All, I know this may be silly but meh! We're all getting older here, even you young ones! In saying that, I've never had the notion that I am old. After all, I play video games among other things and (you could ask my wife) I'm probably still considered … |
| | Hi All, There's a gentleman in my department that is retiring this Friday. He's asked me if there is a way to copy all links in his "Favorites" menu in his web browser. He's got a lot of links and to do it 1 by 1 will take him a … |
| | Hi Admin & Moderators, I just wanted to bring to your attention the fact that it seems this forum seems to be in continuos refresh mode for me. I am using IE8 while at work. Just a fyi! |
| | Hi All, I'm a little stuck with one table's design. I have a table called tblConference_Board that will be updated approximately 3 to 4 times per year. The following is my table design: `CB_ID int (PK)` `CB_Mnemonic_ID int (FK)` `CB_Value decimal (18,10)` `CB_Year int` `CB_Quarter int` This table is loaded … |
| | Hi All, I have a table that holds monthly data in it. I need to average that data into Quarterly and Annual data but I'm not sure how to go about that. For annual I tried something like: SELECT TOP (100) PERCENT b.vSeries_Type as [Description],b.vSeries_Number as [CANSIM], Year(a.IPI_Ref_Date)as [Year], avg(a.IPI_Value) … |
| | Hi All, I created a small executable that runs an SSIS project. It works on my system but when I tried using it on a colleagues system nothing happens. I'm not overly familiar with with part of Java so any suggestions will be most appreciated. |
| | Hi All, I sort of want to get a "best practices" perspective regarding numeric values. First, I'll give my scenario: In my SSIS package, a CSV file is used for data extraction. Once extracted, a staging table is loaded with all the values from the CSV. One column, called "IPI_Value" … |
| | Lmao, I just had a post voted down (I'm guessing) because it wasn't right as far as the code went. That's fine with me but a post that was "more correct" didn't get a vote up. Finicky people on forums. Anyways, it's my first since joining 10 months ago. |
| | Hi All, I'm working on filling a user variable called "EmailString" via a db connection with SSIS. I've created a script task to do this (the only way I can see how) and in it I have the following code: Public Sub Main() ' ' Add your code here ' … |
| | Hi All, I started this general discussion because I want to know what kind of standards you all work by with regards to documenting your projects. I've been steadily working on a system at work since last spring that is automating (extracting, transforming, & loading) data flows within my department. … |
| | Hi All, I am attempting to execute a dtsx package using Java and I have the following line Process executionProcess = Runtime.getRuntime().exec("dtexec/f\"C:\\Projects\\EconAnalysisConferenceBoard\\EconAnalysisConferenceBoard\\EconAnalysisConferenceBoard\\ConferenceBoardETL.dtsx\""); I keep getting an error saying the file cannot be found but if I run the dtexec in command prompt with the exact same paths and file name … |
| | I don't know where this can go or even if there is someone here that can help so bear with me. I am creating a PDF document for my manager that's a combination of PDF files as well as Excel files. The Excel files contain data sets and all I … |
| | Hi All, Forgive me if this doesn't come accross clearly. I have a specific data set to get from a website. Most of the data sets that I get from this site have publication dates that I have been able to successfully use for our SSIS ETL processes. However, one … |
| | I just wanted to say that the menu bar at the bottom of the page is great. Nice job Dani and whomever else worked on this idea. My only problem that I can not is with regards to the cursor being hovered over any link in IE8 because when I … |
| | Hi All, I have the following statement which is intended to have a Year over Year Percentage change: select CurrYear.Variable_Date,CurrYear.Variable_Value,cast(100*(CurrYear.Variable_Value-PrevYear.Variable_Value)/PrevYear.Variable_Value) AS Percentage_Change from dbo.tblCPISC as CurrYear left outer join dbo.tblCPISC as PrevYear on year(PrevYear.Variable_Date) = (select MAX(Variable_Value) from tblCPISC where year(Variable_Date) < year(CurrYear.Variable_Date)) order by year(CurrYear.Variable_Date) For some reason, I … |
| | Hi All, I am wanting to round up my values at query time to 0 decimal places from 2 decimal places. I have SELECT DISTINCT b.vSeries_Table_Number, b.vSeries_Number, b.vSeries_Geography, b.vSeries_Type, b.vSeries_Unit_Type, a.Variable_Date, ROUND(a.Variable_Value, 0) AS 'Value' but the output still has the 2 decimal places which are 0s and pointless in …  |
| | Hi All, I'm having a go at SQL queries and have the following: SELECT b.vSeries_Table_Number, b.vSeries_Number, b.vSeries_Geography, b.vSeries_Type,b.vSeries_Unit_Type, a.Variable_Date, a.Variable_Value FROM tblPopulationSC AS a INNER JOIN tblVSeriesList AS b ON a.vSeries_ID = b.vSeries_ID and b.vSeries_Geography='Manitoba' --and b.vSeries_Unit_Type=' 15 to 64 years' and b.vSeries_Type=' Both sexes' and b.vSeries_Unit_Type=' 65 years and …  |
| | Hi all, I am attempting to rename a file using the File System Task Editor in SSIS. In the Expression Builder, I have @[User::fileName]+(DT_WSTR,2)DATEPART("mm",GETDATE())+(DT_WSTR,4)DATEPART("yyyy",GETDATE())+".zip" but it returns the following error: > TITLE: Expression Builder >------------------------------ >Expression cannot be evaluated. >------------------------------ >ADDITIONAL INFORMATION: >The data types "DT_I4" and "DT_WSTR" are incompatible … |
| | Hi all, This is something I should know but for some reason the answer is eluding me. In a SSIS Script Task Editor, I am trying to set a package String variable called ReNameFile with the following VB.NET line using DateParts for month and year: Dts.Variables("User::ReNameFile").Value = Dts.Variables("User::fileName").Value.ToString + DatePart(DateInterval.Month, … |
| | Hi all, I have a csv that has over 800,000 records that gets loaded into my db via SSIS package routines. However, there are about 190 records that I do not want to be loaded into the the database. The csv comes from an external source and is unaltered at …  |
| | Can someone please help with [this thread](http://www.daniweb.com/software-development/vbnet/threads/436922/how-can-i-create-a-fees-reminder-working-with-access-as-db-and-prompting)? I was thinking that the answer should be in the form of SQL but the op wants a .NET solution. |
The End.