barmatt80
Last Activity: Aug 18 '11, 05:55 PM
Joined: Dec 26 '07
Location:
-
thanks for the help i got it figured out, i changed it to text and was able to pass the null or date to the web service. -
date in web service
I have a webservice that accepts a date which ultimately submits to a sql server 2008 database with a data type of date (allows null values), however the infopath form that submits that date sometimes might be blank or null.
I can't figure out how to check if the date variable the web service is accepting (datStartDate) is blank or null from the form, and if null/blank then submit a Null value to the database, if not null send the... -
Thanks guys. This time we looped through via the code. But i am going to work next week to get a webservice to accept an array and then look through.
where should i put the loop in the web service? just at the execute part, or loop through all the code?Leave a comment:
-
The problem i am having is that code works great for inserting one record. But say I had 10 or 20 ID's i needed to submit. is there a way that I can do a for each loop or something to submit them via one call or do i have to submit them one by one?Leave a comment:
-
Submit repeating/multiple items to stored procedure via webservice
I am trying to what i think is an easy task, but so far i have came up empty.
What i want to do is take a repeating table on a form i have and submit the employee IDs to a database using a web service.
I know how to submit them one by one, but i am thinking there is an easier way to do this instead of send the value to the web service, submit thee data, and then go till the last record.
I am currently... -
thanks missinglinq... your suggestion did the trickLeave a comment:
-
good idea i'll give it a tryLeave a comment:
-
Parse field that contains \n as a delimiter
We have a program that runs on a linux machine that outputs a text file. The description field has \n as line breaks.
here is an example:
\nSynopsis :\n\nError on machine.\n\nDes cription :\n\nThere is a report of volnerability\n this would make the computer at risk\nSolution :\n\nSolution:\ nInstall new patches
Is there a way to make the \n as line breaks on a report or form?
I currently... -
doesn't that say if Ord_Name is a null value, give it a empty string value?
is it that easy?Leave a comment:
-
Null values and web service
I am stumped on a web service.
I have a web service that calls a sql stored procedure. the procedure has 1 input and 20 output paramenters.
I can call the stored procedure just fine and it works, but the problem i am having is values in the database are null values.
How do i handle this so it does not kill my web service?
Thanks for the help -
frontpage and custom from email address
there is a website i was asked to look at ( i have no clue why as i have never done much web development expecially with frontpage extensions).
they want to setup a form on the page that will automatically allow users to subscribe to a listserv for updates.
listserv guys said it will pull the email address out of the email header and the body needs to contain Subscribe <list name> <name of the person requesting>... -
Frinavale, thank you very much for the help. I always find this place a wealth of knowledge. Least I can do is post my code that I got to work. Sorry for the delay in posting back, but i reorganized my favorites and couldn't find anything. I have since made 3 more web services and combined some processes within stored procedures rather than doing the owrk in web service.
My stored procedure had one input variable(@email 0) and returned...Leave a comment:
-
Oh my bad on the ExecuteNonQuery , i read somewhere where to use it if it returned one record, which is what i am looking for.
I'll make some changes later on this evening after i get off work and give it a try.Leave a comment:
-
cool, let me give it a test here in the next couple hours and i'll let you know what i find out.
been a bit busy lately.
i appreciate your help.Leave a comment:
-
I am thinking i am missing something totally simple.
Any suggestions?
thanks for the help.
I'll keep banging away on it.Leave a comment:
-
thanks for all the help. finavale I attempted the class again, just could not get it to work.
The ultimate goal is deploy this to our sharepoint servers for use with infopath forms. When i try the class, infopath recognizes the class(the fields defined within the class) as query fields not data fields.
But this is what I got.
...Code:<WebMethod(Description:="TEST: leave info")> _ PublicLeave a comment:
-
well i got the webservice to work.....partia lly.
I can pass my input variable,but I only get one variable back. I tried a class or a structure, but no go.
My input is an integer (intEmployeeID) and my outputs are string(strFName ), string(strLName ), integer (intAnnual), integer (intSick) and a couple other.
Suggestions on this?
Thanks.Leave a comment:
-
Web service to call sql stored procedure
I don't know if this is the right part of the forum. But.... I have been working all night trying to create a web service to call a stored procedure in sql server 2008. The stored procedure calls a linked server to a db2 database that accepts 1 integer and returns 6 variables.
The end result would be publish the web service to our sharepoint servers. This is not a problem.
I am just trying to wrap my head around... -
Am I over simplifying this? So change the data connection in the cold fusion administrator and that is it? Granted like you said the queries work the same in sql and that names of database fields and data types remained the same?
if so that is awesome! Thanks for your help!Leave a comment:
-
Access 2000 db to Sql server 2005 db
How hard is it if you already have the site setup as access as the datasource to then take that same site to start using sql server 2005 db? Not the actual process of moving the database, but as far as making the site work with sql server opposed to the access db.
a bit more info:
I don't know anything about coldfusion. But we have someone that wrote a website using cold fusion and the data source is access 2000. ...
No activity results to display
Leave a comment: