Status Code: 404 When Retrieving a File

[Pizzadude]

I am retrieving a file in an xbasic function. The file exists in a sub folder of the webroot.
It works fine on the development machine, but on the live web server it fails.
The console error is...

Untitled.png
Is there a setting somewhere that allows access to the folder?

Any ideas?

[Steve Workings]

Does your web server security allow .bmp files?

[Pizzadude]

In Project Properties > File Download > Allowed Filenames I have *.bmp listed.
And in Allowed folders, I have <ApplicationRoot>\temp, which is where the file is located.
Are there any other settings for this?
The strange thing is that it works on the development server but not on the WAS.

[peteconway]

would be helpful is you show the syntax of the function.

[peteconway]

Reminder of what a 404 error is.

404 errors: These occur when a page can't be found. This can happen if the page has been deleted or if the URL has been typed incorrectly. 400 errors: These indicate that the server is unable to process the request. This can happen if the website is down for maintenance or if there is an error in the code.

[peteconway]

have you checked it in the temp folder in the webroot?

[Pizzadude]

What I am doing is a little more complicated. I have done some more analysis...

I want to give the user the ability to preview and edit the body of an email in a UX, before sending the email.
I have integrated CK Editor into a Tabbed UI, and the UX is opened in the Tabbed UI.
There is a Textarea control that is using CK Editor to display the email body, where it can be edited.
When the UX is opened, an xbasic function populates the Textarea control with html that includes an email signature, including an image.
As part of the function, the image is retrieved from a MySQL table, and placed in a folder.
Then the image is inserted into the html using stritran().

The issue is that the WAS and the development server require a different path to find the image file.
So the 404 error was happening on the WAS but not on the development server.
When I started this thread I had not pinned that down. I thought it was a security or permission issue on the WAS.
So the question is: Why should the paths need to be any different?

function populateFields as c (e as p)

dim js as c
dim flag as l
dim sql as c
dim cn as sql::Connection
dim args as sql::Arguments
dim rs as sql::ResultSet

dim appRoot as c

appRoot = a5_removetrailingbackslash(request.applicationRoot)

dim _compID as c = session.Company_IDFK
args.add("compID",_compID)

dim _compName as c = session.CompanyName

dim _userID as c = session.Employee_IndexPK
args.add("userID",_userID)

dim _userName as c = session.current_username

dim _messType as c = e.datasubmitted.MessageType
dim _truck as c = e.datasubmitted.TrailerType
dim _whatday as c = e.datasubmitted.WhatDay

sql = <<%sql%
SELECT Phone1,Fax,Email,CompWebSite
FROM users
WHERE Employee_IndexPK = :userID
%sql%

flag = cn.open("::Name::FreightzoneMySql")

flag = cn.execute(sql,args)

rs = cn.ResultSet

dim _body as c

dim _phone as c = mask(rs.Data("Phone1"),"( )| - ")
dim _fax as c = mask(rs.Data("Fax"),"( )| - ")
dim _email as c = rs.Data("Email")
dim _webSite as c = rs.Data("CompWebSite")

sql = <<%a%
SELECT EmailImage
FROM text
WHERE Company_IDFK = :compID
%a%

flag = cn.execute(sql,args)

rs = cn.ResultSet

' Creates the image to embed in the email.
dim _emailImage as b = rs.Data("EmailImage")
FILE.from_blob(appRoot + "\temp\\" + _compID + "_Image.bmp",_emailImage)
dim _emailImageFileName as c = appRoot + "\temp\\" + _compID + "_Image.bmp"

' THIS IS THE STRANGE PART:
dim _imagePreview as c = "\MyApp\temp\\" + _compID + "_Image.bmp" ' 1-11-23 1045 This works on dev server but not on WAS
dim _imagePreview as c = "\temp\\" + _compID + "_Image.bmp" ' 1-11-23 1045 This works on WAS but not on dev server.

msg = <<%html%
<p>
I found a *truck* that can pick this up*whatDay*<br /> <br />
Please send!<br /><br />
Thanks,
</p>
<p>
*name*<br />
*phone*<br />
*fax*<br />
<a href="mailto:*email*">*email*</a><br />
<a href="https://*website*">*website*</a>
</p>
<p>
<img alt="" src="***emailImage***" style="height:82px; width:158px" />
</p>
%html%

msg = stritran(msg,"<p>","<p><span style=\"font-size:16px\">")
msg = stritran(msg,"</p>","</span></p>")

if _messType = "Is This Available?" then
msg = stritran(msg,"I found a *truck* that can pick this up*whatDay*","Is this load still available?")
msg = stritran(msg,"Please send!<br />","")
end if

msg = stritran(msg,"*Truck*",_truck)

if _whatday <> "" then
msg = stritran(msg,"*whatDay*"," " + _whatday + ".")
else
msg = stritran(msg,"*whatDay*",".")
end if

msg = stritran(msg,"*name*",_userName)
msg = stritran(msg,"*phone*",_phone)
msg = stritran(msg,"*fax*",_fax)
msg = stritran(msg,"*email*",_email)
msg = stritran(msg,"*website*",_webSite)

msg = stritran(msg,"***emailImage***",_imagePreview)

endpopulateFields:

cn.freeResult()
cn.Close()

js = js + "{dialog.Object}.setValue('BodyText','" + js_escape(msg) + "');"

populateFields = js

end function

[peteconway]

The question really should be why you aren't using a viewbox?

[Pizzadude]

We're back...

The question really should be why you aren't using a viewbox?

That's a good question.
I use a lot of list controls in my application. They interact with other components. they have lots of built in functions, method, events, etc.
I'm sure that if I was well versed in viewboxes I could replace all my list controls, but it would be a huge undertaking.
I have implemented a few simple viewboxes, but I don't know how easy it would be to do everything list controls are capable of.
For example, how would I duplicate Multiple Layouts in a viewbox? Is there documentation on this?
I don't see a performance issue with list controls.

Nothing against viewboxes. I just haven't been bitten by the viewbox bug.

[peteconway]

bump - have you checked it in the temp folder in the webroot? is it there on the server?

[Pizzadude]

Yes the file exists. The problem is defining the path to the file:

dim _imagePreview as c = "\MyApp\temp\\" + _compID + "_Image.bmp" ' 1-11-23 1045 This works on dev server but not on WAS
dim _imagePreview as c = "\temp\\" + _compID + "_Image.bmp" ' 1-11-23 1045 This works on WAS but not on dev server.

[peteconway]

Why are you referencing the folder location as \temp\\ and not \temp\ - there can't be a nothing folder in a path unless I'm missing something.

[Pizzadude]

The backslash is an escape character.

[peteconway]

Yes I remember - this is one I did some years ago to output the result as a csv file. So it looks like the you need to escape the lot.

Pete

function savedata as c (e as p)
dim data as c
data = e._viewboxdata
dim csv as c
csv = extension::json::JsonToCSV(data )
dim folder as c = "c:\data"
dir_create_recurse(folder)
dim fn as c = "c:\data\viewboxdata.txt"
FILE.from_string(fn,csv)
dim js as c
js = "alert('data was exported in csv format to c:\\data\\viewboxdata.txt');"

savedata = js
end function

[madtowng]

I could be wrong, but when testing on the dev server , what happens if you put your temp folder in C:\A5Webroot\LivePreview ?