ADDING .PDF TO MY CFOUTPUT FROM QUERY 1

[kingjjx]

Hi, I am outputing a query from a database. I am linking the CFOUTPUT to a file in a folder. The problem here is the files in the folder ends in .PDF however the names in the database only has the name without the .PDF at the end.

I tried doing <cfoutput>

http://www.www.com/files/#file#.PDF

however that doesnt seem to work. Any advice on how to give the cfoutput a .PDF ending ??

hope i explained this ok.
THANKS

 

[Sarky78]

what is the code outputting ?

what is the code that you are using ?

does the pdf exist in the directory that you are looking in?

 

[kingjjx]

the code looks something like this:
<cfoutput>
<a href=&quot;

http://www.www.com/pdfs/#fiel1#&quot;>#file1#</a>

All the pdf files are in the folder called pdf.
now, file1 is taken from a database table column called files. however it will just return the file name (#file1# returns the name file1 ). My question is, is there anyway I can add a .PDF extension at the end ?
I tried doing #file1#.pdf .. however that doesnt seem to work. is there a function i can use or something ?

thanks
-jon

 

[kingjjx]

Hi, basically to explain it in simpler terms, how can i add the .PDF extension to all my query returns ?
EXAMPLE.
QUERY PAGE:
<cfoutput>#names#</cfoutput>
****
RESULT:
john nancy ben

I am querying from a database and its returning John, nancy .. how can i add a .pdf at the end of john, nancy ? the reason i want to do this is bcoz i want to link them to pdf files i stored in a folder.

 

[Guest_imported]

You code has a syntax error. This should work (hint: it's not the same as yours):

<a href=&quot;

http://www.www.com/pdfs/#file1#.PDF&quot;>#file1#</a>

 

[kingjjx]

Hey A440guy, i saw the typo on my code. I tried doing what you mentioned above but I guess the person who created the database set the field to have a max of 20 characters (im not sure if this is the reason) so doing this ..
<a href=&quot;

http://www.www.com/pdfs/#file1#.PDF&quot;;>#file1#</a>

SHOWS:

http://www.www.com/pdfs/file1

.PDF

** there's a huge space between file1 and .PDF and when you click on it .. it shows a bunch of %20%20%20 between file1 and .PDF .. in fact it shows this :

http://www.www.com/pdf/file1 .PDF

ANYTHING I CAN DO ?

 

[Guest_imported]

Oops! I had the same typo that you had. My bad. The problem is the semi-colons. Delete them. Semi-colons are not valid attribute names! &quot;What?&quot;, you say. Attribute names?

Yes. Your <a> tag has TWO attributes, &quot;href&quot; and &quot;;;&quot;. If you parse the tag, you see:

<a
href=&quot;

http://www.www.com/pdfs/#file1#.PDF&quot;

;;
>

 

[kingjjx]

Hey, sorry about the typos again but they are not the reason why its not working. I took them off and still shows the same result.
You can try and view the page at

http://dynamic.dynojet.com/cfml/Query/atvarcticjetstest1.cfm

and click on any stockcode ...

thanks

 

[calista]

I see what you mean about the spaces. Are the spaces in the database? It's a pain, but you could use the RTrim function to remove the trailing spaces. Calista :-X
Jedi Knight,
Champion of the Force

 

[kingjjx]

Hey, thanks for your help guys !
In finally solved my problem. I used the TRIM function
<a href=&quot;

http://www.www.com/pdfs/#trim(file)#.PDF&quot;>

thanks

 

[Guest_imported]

That's the ticket!

 

[kingjjx]

Hey guys, i was just wondering... if you guys can please go check out the test site ..

http://dynamic.dynojet.com/cfml/Query/atvarcticjetstest1.cfm

how come when you click on the stockcode, it shifts the rest of the rows down and click it again and it will finally bring you to the linked page. how come its not linking ti right away ?

any ideas ?

 

[calista]

Works for me. Calista :-X
Jedi Knight,
Champion of the Force

 

[Guest_imported]

I don't get that behavior. It work fine for me in both NS and IE.