Looping, Setting and Updating! Oh My.

-

hello all, new cf , our regular guy on vaction use help. getting geo location bing multiple address have in db. add latitude , longitude latitude field , longitude field in respective row able run function(s) indivulally need looping through each row. here have. hope makes sense!

 

 

 

<!---query db--->

 

 

<cfquery datasource="square" name="listingshort">

     

            select

                                        mls_id,list_price,public_address,street_number,street_name,unit_number,city,zip_code,subd ivision_name,bedroom,baths_total,full_baths,half_baths,square_feet,lot_sqft,garage_capacit y,garage_type,high_school,junior_school,property_description,listing_office_name,listing_o ffice_id,listing_agent_name,listing_agent_phone,listing_agent_id,short_sale,open_house_fla g,last_image_update,price_change_date,image_count,latitude,longitude

       

            glvar_daily_bulk

   

                      where mls_id=1375233

  

</cfquery>

 

 

<!---get data bing--->

 

 

<cfhttp url="http://dev.virtualearth.net/rest/v1/locations/us/nv/#listingshort.zip_code#/#listingshort. city#/#listingshort.street_number#%20#listingshort.street_name#?o=xml&key=agm3wr0ojspxyaje h6ws7p2kcckecqvq5hkrwefczccyoje3myvvirf_wzbetmeb" timeout = "2" method="get">

 

 

<cfset xbinglocation = xmlparse(cfhttp.filecontent)>

<cfset lat=xbinglocation.response.resourcesets.resourceset.resources.location.point.latitude.xml text>

<cfset long=xbinglocation.response.resourcesets.resourceset.resources.location.point.longitude.x mltext>

 

 

<!---update latitude , longitude fields--->

 

 

<cfquery datasource="square" name="addgeo">

 

                              update glvar_daily_bulk

                              set latitude = #lat#,

               longitude = #long#

               mls_id=1375233

           

</cfquery>

do need loop on rows, or of them?  i'm assuming former.  in case modify first query records, move rest of code loop on query.

 

<!---query db--->

<cfquery datasource="square" name="listingshort">

    select mls_id,street_number,street_name,city

    glvar_daily_bulk

</cfquery>

 

<cfloop query="listingshort">

    <!---get data bing--->

    <cfhttp url="http://dev.virtualearth.net/rest/v1/locations/us/nv/#listingshort.zip_code#/#listingshort. city#/#listingshort.street_number#%20#listingshort.street_name#?o=xml&key=agm3wr0ojspxyaje h6ws7p2kcckecqvq5hkrwefczccyoje3myvvirf_wzbetmeb" timeout = "2" method="get">

 

    <cfset xbinglocation = xmlparse(cfhttp.filecontent)>

    <cfset lat=xbinglocation.response.resourcesets.resourceset.resources.location.point.latitude.xml text>

    <cfset long=xbinglocation.response.resourcesets.resourceset.resources.location.point.longitude.x mltext>

 

    <!---update latitude , longitude fields--->

    <cfquery datasource="square" name="addgeo">

        update glvar_daily_bulk

        set latitude = #lat#,

        longitude = #long#

        mls_id = #listingshort.mls_id#

    </cfquery>

</cfloop>



More discussions in ColdFusion


adobe

Comments

Post a Comment

Popular posts from this blog

Adobe Acrobat Pro , Terminal Server Use

-
hello,   a fellow employee requires adobe acrobat pro installed use, , management me have sorted out. employee uses thin client connect terminal server of administration work.   i require single license adobe acrobat pro used single user.   will there license issues installing adobe acrobat pro on terminal server?   can install adobe acrobat pro on terminal server?   thanks, david hi david,   yes, can install acrobat terminal servers... !   the licensing terminal server considered normal licensing process, means need buy many number of licenses acrobat number of users accessing terminal server (like citrix) access software. eg if 10 users accessing citrix server @ particular time use acrobat software need 10 licenses same. More discussions in Installing, Updating, & Subscribing to Acrobat adobe
Read more

Thread: transmission-daemon isn't playing nice: "409: Conflict"

-
409: conflict request had invalid session-id header. fix this, follow these steps: when reading response, x-transmission-session-id header , remember it add updated header outgoing requests when 409 error message, resend request updated header requirement has been added prevent csrf attacks. error occurs when apache not running. i've tried zillion different proposed solutions involving rewriterules , proxypasses golly i'm clueless. me? following apache thing, y'know, in case. code: <virtualhost *:80> rewriteengine on documentroot /var/www <directory /> options followsymlinks allowoverride none </directory> <directory /var/www/> options indexes followsymlinks multiviews allowoverride none order allow,deny allow </directory> scriptalias /cgi-bin/ /usr/lib/cgi-bin/ <directory "/usr/lib/cgi-bin"> allowov...
Read more

Thread: gpg: Conflicting Commands

-
Image
hi, relatively new linux (have used many live disks) , have had install of ubuntu 12.04 few days now. part have found easy use , have been comfortable it. have first question can't resolve myself: adding googles repository list. when first ran command supplied google found did not have wget installed. used apt-get install it. worked fine (as far can tell) re-ran googles code : wget -q https://dl-ssl.google.com/linux/linux_signing_key.pub -o- | sudo apt-key add -deb http://dl.google.com/linux/deb/ stable non-free , message 'gpg: conflicting commands' tell me going wrong , how fix please new script : wget -q https://dl-ssl.google.com/linux/linux_signing_key.pub -o- | sudo apt-key add linux_signing_key.pub need edit /etc/apt/sources.list , add line @ end deb http://dl.google.com/linux/deb/ stable non-free end hope find usefull edit: need root or use sudo make changes /etc/apt/sour...
Read more