Developer Barn

Email Form problem

jimt — Sat, 04 Feb 2012 13:37:28 GMT

I'm using formmail to send a simple input form by email. Our server doesn't support it so we're using formmail.com to process the email.

The form has 5 inputs: name, email, phone, estimate checkbox, comments along with a hidden subject input. The problem is that the return email adds the phone number to the subject - subject, phone#

Here is the code:

Code:



                        Name: 


                        


                        

                            

                        


                      

                      

                        

                            Email Address: 


                        


                        

                            

                        


                      

                      

                                          

                        

                            : 


                        


                        

                            

                             Request a Quote


                      



                        

                        

                            Telephone Number: 


                        


                        

                            

                        


                      



                      

                        Comments:

Any hel would be greatly appreciated,
Thanks,
JimT:rolleyes:

;

Error with the script !

simplyeshu — Sat, 04 Feb 2012 07:20:24 GMT

Hello Frens,

I have written a small script to move the files from two directories to one main directory. It should record all the activities in a log file like files have been moved successfully from directory b to directory A and total number of files moved along with timestamp but its not working. Can you please review and help? Appreciate your help. Also tell me if we can automate this to run everyday at particular time (between 10pm - 11pm)

echo "files moving at "%date%-%time%" >> c:\OutputFile.log
move "C:\A\*.*" "C:\Test" >> C:\OutputFile.log
move "C:\B\*.*" "C:\Test" >> C:\OutputFile.log
echo "files moved at "%date%-%time%" >> c:\outputfile.log

Reading XML Node List

richyrich — Thu, 02 Feb 2012 13:41:01 GMT

I'm connecting to a webservice to retrieve an XML list, but I can't seem to work out how to read all the nodes. This is what I'm getting back:-

Code:





       

                     

                     Price Band Name

                     Allocated Prod Type

                           

                                  GB

                                  90

                                  GBP

                           

                           

                                  US

                                  135

                                  USD

                           

                           

                                  JP

                                  27500

                                  JPY

                           

                           

                                  HK

                                  135

                                  HKD

                           

                           

                                  CN

                                  135

                                  USD

I need to read all the elements inside each PriceBand node.

Code:

XmlNode result = responseXML.SelectSingleNode("/Result/PriceBands");

            foreach(XmlNode node in result.ChildNodes)

            {

                this.ltlResponse.Text += node.SelectSingleNode("/Name").InnerText;

                XmlNodeList countryList = node.SelectNodes("PriceBand/Country");

                foreach (XmlNode countryNode in countryList)

                {

                    this.ltlResponse.Text += countryNode.OuterXml.ToString() + "
";

                }

            }

So, I presume it's not able to retrieve this node. How do I read a node of a childnode?

Any ideas?
But I get an object reference error on the line in red

Repeater

Emily P — Wed, 01 Feb 2012 21:41:04 GMT

Hi I've setup a repeater on my page it works great the only problem is it's repeating at the top of the page instead of in the section it's in a table. I tried adding the valign but no success.

Code:

checking if a checkbox is checked then doing some stuff

PD24 — Wed, 01 Feb 2012 16:01:10 GMT

I want to check if a checkbox is checked, i have this code:

Code:

$($checkbox).each( //this will check if there is a checkbox in the form thats checked.

    function() { 

       alert($checkbox);

       checkboxFound = 1

    

    } 

    );

I want to then pass the result true in the form of checkboxFound = 1 where i want to use this variable else where in my code.

When i debug the checkbox it says its holding a value of :

"Input 849"

Later in my code i have the following:

Code:

if (totals > 1 && $textarea > "" && checkboxFound > 0)  //if the total is more than 0 and theres text in the box do the following

    

{.....

.........

any ideas because it should pass the if statement and then toggle my form...

But its not working....

:(

Firefox 10 Released

jmurrayhead — Wed, 01 Feb 2012 14:30:11 GMT

Seems like just yesterday we were all on Firefox 5. It feels a little bit faster and some of the more serious jQuery bugs that were introduced in version 9 appear to be fixed.

T-SQL EXPORT to CSV file

grnzbra — Tue, 31 Jan 2012 17:59:16 GMT

I have the following code that works very nicely

Code:

BULK INSERT #TempTable

       FROM 'd:\CSVFile.csv'

       WITH

         (

            FIELDTERMINATOR = '|',

            ROWTERMINATOR = '\n'

          )

I now need to reverse the process - export to a csv file with pipe delimiters. How can it be done with T-SQL?

(Note: for some reason, when this is displayed here, the FIELDTERMINATOR ends up looking like a slash. It isn't a slash; it's a pipe.)

Passing parameters in asp.net

Emily P — Mon, 30 Jan 2012 16:36:25 GMT

Hello I am still trying 5to convert my old asp pages to asp.net. I am stumbling upon the transfer of a parameter to the next page.

In the first page I have href="FrmRentersAccessSearchApartments.aspx?City=F lamborough" />

And in the FrmRenterAccessSearchApartments page I would like something like the following, I was hoping someone could help me see if I need to do this in the C# or the ASP? Not quite sure where to go from here?

Code:

 area = HttpContext.Current.Request.QueryString["City"];

                if (String.Compare(area," ") == 0)

                {

                     area =

                     "Ancaster' OR 'Dundas' OR 'Flamborough' OR 'Glanbrook' OR 'Grimsby' OR 'Hamilton Central' OR 'Hamilton Downtown' OR 'Hamilton East End' OR 'Hamilton East Mountain' OR 'Hamilton North End' OR 'Hamilton West' OR 'Hamilton West Mountain' OR 'Stoney Creek - Lower' OR 'Stoney Creek - Mountain' OR 'Waterdown"

                 ;

                 }

Thanks Emily

select from xml field

altarek — Sat, 28 Jan 2012 11:23:29 GMT

i have mysql xml field like this

Code:




    xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"

 

    xmlns="http://www.loc.gov/MARC21/slim">

 

  00764nas 

  011258

 

  

    jan

  

  

    samy

    

  

  

    ali

    22

  

  

    

    1984

I want query to retrieve data from it like(Jan , samy)
i tried to use ExtractValue but my version not supported it
is there another way to select from this field?

T-SQL ENABLE TRIGGER problem

grnzbra — Fri, 27 Jan 2012 19:12:55 GMT

I have a stored procedure that enters records into a table that has an INSERT trigger, which I do not want to be enabled while my stored procedure is running. By inserting a DISABLE TRIGGER statement at the beginning of the stored procedure, I can prevent the trigger from firing. However, when I try to add and ENABLE trigger command at the end of the procedure and then try to run the ALTER PROCEDURE script to make the ENABLE TRIGGER statment part of the procedure, I get an error telling me that there is a syntax error by the word TABLE.

However, if I try to run the ENABLE TRIGGER statement by itself, it runs fine. I copied and pasted the statement straight from Microsoft HELP and then copied the trigger name and table name from object explorer to the appropriate places in the ENABLE TRIGGER.

What might be causing this behavior in SQL Server 2005?

New General Hardware Forum

jmurrayhead — Fri, 27 Jan 2012 19:07:19 GMT

So, we have specific hardware-related forums, but not a catch-all for everything else. Well, now we do. Check out the new General Hardware forum which can be used for...general hardware topics, such as building a new PC and so on and so forth.

show hide DOM jquery dilema?

PD24 — Fri, 27 Jan 2012 17:11:36 GMT

I have the following code which hides the customised price from the page:

Code:

$(document).ready(function() {

    $("div.testing div b:contains('Customised Price:')").css("visibility", "hidden");

    });

Then i have this code which opperates the show hide:

Code:

$(document).ready(function() {

    $('.customise-showhide-button').click(function () {

    $('div#KitFormOptions').slideToggle();

    $('div#KitFormOptions').scrollView();

    $("div.testing div b:contains('Customised Price:')").css("visibility", "visible");



});

});

If you want the product without customisations you just enter a quantity and add to cart. You must not see the customised price - this works well.

When the user clicks the showhide button the customisations form will scroll down. The problem is the DOM has fully loaded and i cannot inject and more jquery. So this line does not work:

Code:

$("div.testing div b:contains('Customised Price:')").css("visibility", "visible");

What could i do?

Spreadsheet upload import facility

PD24 — Fri, 27 Jan 2012 10:49:39 GMT

I have built a website for a client but due to politics of XYZ i find out they are not computer literate enough to understand how to use a CMS / Rich Text Editor / DNN module for product info / images.

They have a huge spreadsheet of specifications. I was planning on building an upload facility which will pass the spreadsheet into the system so that my application will then read columns category, product type, voltage, watts, MWatts, KwATTS etc etc

The idea is to upload the spreadsheet and then import the data to SQL Server. Then the site should display the data based on this. If they wish to ammend the site, eg delete products from the Car or Home section then they just delete the row from the spreadsheet and re-upload.

Problem is how would I upload the images for each product?

-Could i add a row to the spreadsheet and call it image number? then get them to do a batch upload of images. The application will then read the unique IDs from the images. Eg, XPC123.jpg (XPC) being the category.

I then will style the pages and create links for the categories and product pages.

Thoughts please? Does this sound like a good idea?

Problem linking subreport data

jimt — Thu, 26 Jan 2012 21:54:25 GMT

I'm having a problem linking a subreport date range.

I have a report that displays data from the cash table - the date range is provided by 2 parameters - startdate & enddate (transdate is between startdate and enddate)- the subreport displays data from the sales table using the same range -when I link the subreport (salesdate) and run the report I get 4 parameter requests - 2 startdate & 2 enddate. The subreport is being run in a report footer if that helps - I can do it for a single day OK or using a date function like last 7 days but not for a date range

I'm sure its something simple so if anyone can PLEASE point me in the right direction :confused:

Thanks in advance for any help,
JimT

not a complete noobie but just enough knowledge to really mess things up!

Tab Strip

Emily P — Wed, 25 Jan 2012 19:42:46 GMT

Can someone help me with the tabstrip code not sure if I've imported the correct namespaces for this?

Code:

<%@ Page language="c#" CodeFile="FrmApproval.aspx.cs" AutoEventWireup="false" Inherits="HousingConnect.WebFormFrmApproval" %>

<%@ Import Namespace="Microsoft.Web.UI.WebControls" %>

<%@ Register TagPrefix="ie" Namespace="Microsoft.Web.UI.WebControls" Assembly="Microsoft.Web.UI.WebControls, Version=1.0.2.226, Culture=neutral, PublicKeyToken=31bf3856ad364e35" %>











  

         FrmApproval



           <%-- Hamilton Housing Help Centre

            




            

            

            

            

            APPROVAL

            

            Hamilton Housing Help Centre

            --%>