CodingSome CFML Stuffs Me Do

 

Press Ctrl+Enter to quickly submit your post
Quick Reply  
 
 
  
 From:  Ken (SHIELDSIT)   
 To:  Ken (SHIELDSIT)      
38447.52 In reply to 38447.51 

What do you suggest the best way to put this data in to a database so I can use it to compare against another database?

 

I will need to check for type of wood and thickness and then pull that value to multiply by.



Attachments:
ScreenShot001.bmp

0/0
 Reply   Quote More 

 From:  Peter (BOUGHTONP)  
 To:  Ken (SHIELDSIT)      
38447.53 In reply to 38447.52 
Um... interesting question.

Not really sure at the moment - would depend what the data to compare against was like.

If it's just standalone data, I'd probably go ahead with one table:

code:
 
CREATE TABLE wood_costs
( species VARCHAR(30) NOT NULL
, thickness TINYINT NOT NULL
, cost      SMALLINT DEFAULT NULL
);
 
INSERT INTO wood_costs ('Red Oak',3,85);
INSERT INTO wood_costs ('Red Oak',4,85);
...
INSERT INTO wood_costs ('Hard Maple',7,135);
...
INSERT INTO wood_costs ('Other Hardwood',16,285);
 


Then extract distinct species and loop through ordered by thickness for outputting cost.

Though some might argue for three tables (with IDs for species and thickness to avoid duplicating data), but not sure that makes practical sense here.

I'm now a bit paranoid that I'm missing the point entirely in what you're asking, and you actually meant something else? :S
0/0
 Reply   Quote More 

 From:  Ken (SHIELDSIT)   
 To:  Peter (BOUGHTONP)     
38447.54 In reply to 38447.53 
No, you understood it perfectly. And that's what I thinking. Just have to either loop through and compare or compare with the sql statement right?


0/0
 Reply   Quote More 

 From:  Peter (BOUGHTONP)  
 To:  Ken (SHIELDSIT)      
38447.55 In reply to 38447.54 
Probably better to compare actual data than SQL statements.
0/0
 Reply   Quote More 

 From:  Ken (SHIELDSIT)   
 To:  Peter (BOUGHTONP)     
38447.56 In reply to 38447.55 
Sweet. Wish I had the proper ports forwarded on my server so I could show you the report. I might get around to that some day.


0/0
 Reply   Quote More 

 From:  Ken (SHIELDSIT)   
 To:  Peter (BOUGHTONP)     
38447.57 In reply to 38447.56 
How do you center a page in XML? I tried <center></center> and it threw a bitch fit.


0/0
 Reply   Quote More 

 From:  Peter (BOUGHTONP)  
 To:  Ken (SHIELDSIT)      
38447.58 In reply to 38447.57 
Well you don't use <center></center> at all for anything, really, because that's not even real HTML.

And you don't "center a page in XML" because XML, in general, describes data rather than layout/formatting, so doesn't have a concept of centering.

To give you a useful answer, I need more information.

What are you actually using - is it XHTML, is it file.xml with a related file.xslt, or is it something else?

Do you mean center like this:
I am centered text
in a left-aligned box.


Or like this:
I'm a centered box,
with left aligned text
0/0
 Reply   Quote More 

 From:  Ken (SHIELDSIT)   
 To:  Peter (BOUGHTONP)     
38447.59 In reply to 38447.58 
Why are the center tags not proper html?

I'm try to do the 2nd example you posted there.

I have a report made and I would like the whole thing centered on the page.

This is an example of the code that I can see.

code:
<?xml version="1.0" encoding="utf-8"?>
<Report xmlns:rd="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner" xmlns:cl="http://schemas.microsoft.com/sqlserver/reporting/2010/01/componentdefinition" xmlns="http://schemas.microsoft.com/sqlserver/reporting/2010/01/reportdefinition">
  <AutoRefresh>0</AutoRefresh>
  <DataSources>
    <DataSource Name="KilnData">
      <DataSourceReference>KilnData</DataSourceReference>
      <rd:SecurityType>None</rd:SecurityType>
      <rd:DataSourceID>0915e801-0c00-4013-a86a-3762972008de</rd:DataSourceID>
    </DataSource>


0/0
 Reply   Quote More 

 From:  Peter (BOUGHTONP)  
 To:  Ken (SHIELDSIT)      
38447.60 In reply to 38447.59 
Because proper HTML is for describing the meaning, not what it looks like (that's what CSS is for).

If this was anything other than Microsoft, I'd say you have an XSLT file somewhere, which transforms that XML into HTML, and you would just need to locate that file and set the left and right margins to "auto" (and assign a fixed width) and the report would be centered.

(That box above was simply <div style="background-color:silver; width:350px; margin:auto;">I'm a centered box,<br />with left aligned text.</div>)

But - because it's Microsoft - they've probably invented their own way of doing it, just because that's what Microsoft does.

And it looks like they have, with their RDL thing. So what you need to do is read their documentation on Layout / Page and see if you can set LeftMargin and RightMargin to auto, or if you need to calculate explicit values to use.

Didn't you mention you had a book on SSRS? This is probably mentioned in there somewhere.
0/0
 Reply   Quote More 

 From:  af (CAER)  
 To:  Peter (BOUGHTONP)     
38447.61 In reply to 38447.60 
XML is great, isn't it? It's so enterprisey.
0/0
 Reply   Quote More 

 From:  Peter (BOUGHTONP)  
 To:  af (CAER)     
38447.62 In reply to 38447.61 
If by "enterprisey" means "bloated worthless shite that appears better on paper but actually takes ten times as much effort to do anything with because it was designed to solve the wrong problem", then yes, it is.
0/0
 Reply   Quote More 

 From:  af (CAER)  
 To:  Peter (BOUGHTONP)     
38447.63 In reply to 38447.62 
That's a nicely enterprisey definition, well done! :D

(although I think adding a few terms like 'blue-sky' and 'process-driven' or maybe 'social media' could corp it up a bit)
0/0
 Reply   Quote More 

 From:  Ken (SHIELDSIT)   
 To:  ALL
38447.64 In reply to 38447.63 
FUCKKKK I have a real fucking strange issue going on with a report I made. And I would like to get a fresh set of eyes on it, but it will be pretty hard to get all the relevant data posted so you would even understand what the fuck I'm talking about. GRRRRRRRRR I hate life.


0/0
 Reply   Quote More 

 From:  Ken (SHIELDSIT)   
 To:  Peter (BOUGHTONP)     
38447.65 In reply to 38447.64 
Have you ever used the CF Report Builder?


0/0
 Reply   Quote More 

 From:  Ken (SHIELDSIT)   
 To:  ALL
38447.66 In reply to 38447.65 
Has anyone checked on PeeB lately? I think his chair attacked him, causing him to fall, and not be able to get up!


0/0
 Reply   Quote More 

 From:  Peter (BOUGHTONP)  
 To:  Ken (SHIELDSIT)      
38447.67 In reply to 38447.66 
My chair did not attack me!

It would never do such a thing to me. :@
0/0
 Reply   Quote More 

 From:  Ken (SHIELDSIT)   
 To:  Peter (BOUGHTONP)     
38447.68 In reply to 38447.67 
Well that was the only logical explanation!


0/0
 Reply   Quote More 

 From:  Peter (BOUGHTONP)  
 To:  Ken (SHIELDSIT)      
38447.69 In reply to 38447.65 
And no, not used CF Report Builder, fortunately.

With CF8/9 Adobe did (attempt to) make it non-shit, but I've not had any reason to see if they succeeded.
0/0
 Reply   Quote More 

 From:  Ken (SHIELDSIT)   
 To:  Peter (BOUGHTONP)     
38447.70 In reply to 38447.69 
I was going to try it, but I'm too dumb to make it work with Ralio.


0/0
 Reply   Quote More 

 From:  Peter (BOUGHTONP)  
 To:  Ken (SHIELDSIT)      
38447.71 In reply to 38447.70 
I've no idea if it'll run against Railo or not - wouldn't be surprised if Adobe had deliberately made it incompatible in some way. :/
0/0
 Reply   Quote More 

Reply to All  
 

1–20  21–40  41–60  61–75

Rate my interest:

Adjust text size : Smaller 10 Larger

Beehive Forum 1.5.2 |  FAQ |  Docs |  Support |  Donate! ©2002 - 2024 Project Beehive Forum

Forum Stats