Hi there I am not sure if this should be an INNER JOIN or not...
What I want is the outcome of the different event_IDs (which sit in tickets, however to get to tickets I need relate back to itin_it…
I have this script which determines if the file exists:
if fs.FileExists("c:\inetpub\wwwroot\"&(rsProducts4("ImageSrc"))&"") then
I have a report which is generated based on a querystring.
Querystring is identified at the beginning of code.
ChartID = Request.querystring("ChartID")
Now I need to use this same query…
I have this script:
if not rs.EOF then
response.write " " & rs("pName")
if SESSION("clientID")<>"" then response.write " (" & rs("pInStock") & ")"
I need to modify it to show "In st…
I have this script:
if useStockManagement AND showinstock=TRUE then if cint(rs("pStockByOpts"))=0 then print "<div class=""prodinstock detailinstock""><strong>" & xxInStoc & ":</st…
I'd like to do a super-massive, sign up, account, upload/post and peer review/grade site.
I have a c# application that needs to modify a value in a .CSV file. Whilst developing the application I have used a local copy of the .CSV file and was able to read the contents of the .CSV file via…
I am looking for a software that will import about 100 csv spreadsheets into a MS SQL 2008R2 database.
I found DBForge software but it only imports one spreadsheet at the time.
Is there a way to i…
I am using summernote as my HTML editor. but I am trying to make the textarea required. Unfortunately is not working. Is there a different way of making summernote requiered ?
This is my code:
The page below is supposed to show the Message recordset when the visible table row is clicked.
It's working fine when I remove the table header, so I commented it out. Is there a way to modify the j…
I have three tables:
tblContractJournals tblContractJournalsSubs tblGeneral
- JournalID - ChartID = Ch…
I am trying to import a CSV file into MS Access and on all the AutoNumber Fields it denies it due to policy error.
I have a SKUs table and I am importing records into it. One field in the SKUs tab…
On my web page I'm displaying database records. One column is named "Comments" and it is varchar(MAX) data type in the SQL Server database.
I have a folder that receives xml files from an external service.
I have to read, process and move each file.
I reload an .asp webpage once a second.
I want to make sure I don't pick up…
Response.Charset = "utf-8"
Response.CodePage = 65001
<!-- #include file="../includes/cnf.asp" -->
mySQL = "select * from MEDICAL order by…
I have the query below, which may return identical records other than the 'logid' being different.
I want to display only those records which are different, in other words, records that are identi…
I want to find out if there is a match, case notwithstanding for a first name, last name, gender. It is my understanding that this will look at "Bob" and "BOB" as different names. Yes? If not pleas…
I'm trying to write a classic ASP script that sends an xml request to an API and parses the response into variables. The send works and the response (.responseText) is the following:
We have this simply html regular asp page:
And the script can´t find the pdftoview.pdf to embed. If we put like this works:
Why is not accepting local routes with c:/... or h…
I have a web page which displays a database record, but it also has images, tables, etc. that I don't want to print.
This page has a Print icon. When it's clicked it takes the user to a page where on…
Hi all, I just need the count number from this Query so I can display it.
Hi there, I have a query that I want to modify so I can get the soonest date from a few different records
The records have dates of expiry, eg
ticket 1 exp=2/12/16
ticket 2 exp=8/5/1=7…
I have a table "Atts" which holds a few values, there maybe duplicate entries. I need a stored procedure that will remove any duplicate entries.
This is the table
any records which a…
Hi there, I am getting an error and cannot figure out where I am going wrong:
It seems that IF I put aspJSON within the IF statement of (If Not CheckCurrUptoDate.EOF Then) it errors, outside of IF,…